Transfer data from one workbook to another workbook based on a key

[Guest]

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.

 

[Guest]

Luther: I don't know what your skill level is with VBA. It can be done. It
looks like you need 3 or 4 list boxes. Both workbooks need a header row with
lables. The list boxes would contain the labels of both workbooks that the
user can select to determine the columns that will be used for matching and
the source column and destination column that gets copied.

Try Lesson 5 on this microsoft website
http://msdn2.microsoft.com/en-us/library/aa203714(office.11).aspx

 

[Guest]

Thank you for the pointer. I am goin to check this lesson.