Updating from one list to anoter

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

john.9.williams@bt.com - 15 Mar 2008 22:02 GMT

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

Reply to this Message

Mark Ivey - 15 Mar 2008 22:43 GMT

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

> 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
[quoted text clipped - 6 lines]
>
> John

Reply to this Message