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

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