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

Tom Brown | 3 Brown Lane | 020241445 | |

WB B

| |

Would give me *WB C*

Bob Smith | 3 Smith Lane | 0204587512 | |

Any way of doing this??

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

Cheers


--
blander
------------------------------------------------------------------------
blander's Profile: http://www.excelforum.com/member.php...o&userid=36486
View this thread: http://www.excelforum.com/showthread...hreadid=569362