Hi:

I have two workbooks 1.xls and 2.xls. Both workbooks have in column A
a list of "jobs" but not in the same order, such as:

1.xls

job 444
job 888
job 222
job 555


2.xls

job 222
job 555
job 888
job 444


What I need is to compare 1.'xls to 2.xls and if it finds the job i
2.xls then copy a cell from 2.xls but 2 columns down from the job to
cell in the same row as job in 1.xls but 9 columns down.

Any help would be appreciated

--
halem
-----------------------------------------------------------------------
halem2's Profile: http://www.excelforum.com/member.php...nfo&userid=993
View this thread: http://www.excelforum.com/showthread.php?threadid=27221