Regi_K
09-12-2011, 07:55 PM
:help
I have a problem that I hope someone can help me with.
I have 2 workbooks that I am working with.
I wish to copy data from workbook 1 to workbook 2 based on the following criteria:
· A value in cell "B1" of workbook 1 needs to equal a value of a cell in column "A" of workbook 2... So it needs to find the corresponding cell with equal value of cell "B1" in column "A". Note the value in cell "B1" is the "key" for the records.
· Once the "key" has been found in row? in Workbook 2, i wish to paste the value in cell "D1" of workbook 1 into the cell in column "E" in this same row as the "key".
Is it possible to do this and if so how can I do this?
Can someone please help me?
Thanks
Regi
I have a problem that I hope someone can help me with.
I have 2 workbooks that I am working with.
I wish to copy data from workbook 1 to workbook 2 based on the following criteria:
· A value in cell "B1" of workbook 1 needs to equal a value of a cell in column "A" of workbook 2... So it needs to find the corresponding cell with equal value of cell "B1" in column "A". Note the value in cell "B1" is the "key" for the records.
· Once the "key" has been found in row? in Workbook 2, i wish to paste the value in cell "D1" of workbook 1 into the cell in column "E" in this same row as the "key".
Is it possible to do this and if so how can I do this?
Can someone please help me?
Thanks
Regi