Hello,

Ideally, I would like to accomplish the following:

1. Have 2 workbooks open
2. Both workbooks would have a column as a key field to match on; this
column can be named ID.
3. Transfer data from workbook1 to workbook2 based on ID matching.
4. The data being transferred does not necessarily have to be in the same
columns; i.e. I should be able to specify (workbook1-column C) goes to
(workbook2 - column G), for example.

This probably should go by pairing like this:

Specify in workbook1 : (ID & COUNT)
Specify in workbook2 : (ID & ASSETS)

essentially, COUNT would be copied to ASSETS based on ID match.

Is there anyway to do this? Interactively, if at all possible.

Any help would be appreciated.