See if this will help:

http://www.ozgrid.com/VBA/ExtractFromClosedWorkbook.htm

If not...

Post the specific workbook name, their full paths, and a brief example of
the data to this thread and I will see if I can come up with something else.

Mark

wrote in message
...
Hi I have a bit of a prob, I have one excel workbook with a data list
on it, and another workbook with another datalist on. every piece of
data in column a workbook1 appears in colum a of book2, I need to find
the position of this data in column a from workbook 2 and copy columns
d, f, e of the first book to the columns of d, f, e of the second
book. any ideas, I am doing a loop at the moment but its taken ages
and would like to speed it up by not activating the second workbook,
any ideas would be great

John