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

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.

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

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/lib...ffice.11).aspx



"Luther" wrote:

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.

Transfer data from one workbook to another workbook based on a
 

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

"Joel" wrote:

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/lib...ffice.11).aspx



"Luther" wrote:

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.