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 | [email protected] |

Tom Brown | 3 Brown Lane | 020241445 | [email protected] |

WB B

| [email protected] |

Would give me WB C

Bob Smith | 3 Smith Lane | 0204587512 | [email protected] |

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..