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

Phoenix