Update values in WkBk1 from WkBk2

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pattlee - 26 May 2008 00:49 GMT

Trying to update cells in Workbook1 from Workbook2 based on a match between
values in Col A in both Workbooks. The value of Col B IN Workbook2 is to be
added to the value in Col O in Workbook1 for each match. Seems simple. Easy
in Access as a query but Excel syntax is very differnet... Would really
appreciate help . Just need to know how to get started using a Macro since
this routine will be used on a weekly basis to update Workbook1... Thanks in
advance . (Both Workbooks will be open to run the code)

Reply to this Message

loudfish - 26 May 2008 21:19 GMT

On May 26, 12:49 am, pattlee <patt...@discussions.microsoft.com>
wrote:

> Trying to update cells in Workbook1 from Workbook2 based on a match between
> values in Col A in both Workbooks. The value of Col B IN Workbook2 is to be
[quoted text clipped - 3 lines]
> this routine will be used on a weekly basis to update Workbook1... Thanks in
> advance . (Both Workbooks will be open to run the code)

If you have a primary key in both workbooks, you can link them using
VLOOKUP.

However, sounds like the key is not unique in one of the workbooks, in
which case I would suggest SUMIF.

Both mean creating links between the workbooks. However, this could be
avoided by copying the entire worksheet contents (CTRL+A, CTRL+C) from
one workbook into the other.

To Automate this, start with the macro recorder, Tools... Macros....
Record New Macro..... then go into the Visual Basic Editor (same menu)
to see what you recorded.

HTH

Andrew

Reply to this Message