Lookup and copy into another file
 

Hi

I need a macro to the following:

I have to files
Book1
Book2

Have to lookup the same value in Book1(B1:B100) as in Book2(H1:H100)
If it matches, data from Book1 Cx,Dx,Ex,Fx etc. will be copied to the
matched value in Book2.

Have to do this from multiple files, so need to run one macro per.
files :confused:

Phoenix


--
Phoenix
------------------------------------------------------------------------
Phoenix's Profile: http://www.excelforum.com/member.php...fo&userid=2921
View this thread: http://www.excelforum.com/showthread...hreadid=520465