Lookup and copy into another file

P

Phoenix

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

comparing values from one workbook with another workbook 3
Linked Cells, Increment Sheet Number Ref. 3
Paste Special in Excel 2003 6
Creating a linked file based on variable location reference 2
How to transfer data from one workbook to another via VBA 0
Copying a Name's Contents 8
Macro needed 3
summary of data from several workbooks in another 6

Top