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

Lookup and copy into another file
 

Anyone ? :confused:


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

Lookup and copy into another file
 

I think I'd start with =vlookup().

You may want to read Debra Dalgleish's notes:
http://www.contextures.com/xlFunctions02.html

Phoenix wrote:

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

--

Dave Peterson