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

L

Luther

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.
 
J

Joel

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top