Okay, we need to know what we're working with.

What column in Workbook A needs to be looked at to find the number.

What column in workbook B matches this number?

Are we looking at duplicate values?

Is it one worksheet in each workbook, or is there multiple sheets in
each book.

Post a sample of the data and describe exactly what you need to have
happen.

Cheers,
Jason Lepack
Brad Torken wrote:
HELP!!

My poor wife has two excel files and thinks she has about 24 hours of work
on her hands so I'm hoping someone here can help. What she has to do is
use the item number from a column in file A, and looking for the same item
number in file B. Then she needs to take a number from the same row but
another column and move it to a new column in file A. Any idea on how I
can do that? She has 200 pages worth to go through and I would hate for
her to have to look up each one individualy.

Thanks!