Copying rows

[blander]

Hi Guys,

I have 2 work books A and B

I want to be able to copy the entire rows out of WB A, which contain
the same data as one of colums in WB B

e.g

WB A

Bob Smith | 3 Smith Lane | 0204587512 | (e-mail address removed) |

Tom Brown | 3 Brown Lane | 020241445 | (e-mail address removed) |

WB B

| (e-mail address removed) |

Would give me *WB C*

Bob Smith | 3 Smith Lane | 0204587512 | (e-mail address removed) |

Any way of doing this??

I know that i could use 'find' then copy the data, except i have around
300 records...

Cheers

 

[blander]

I know how to do this.. but i just dont know VB, on how to achieve it.