Moving data from one workbook to another

I have two workbooks: WorkbookA and WorkbookB. (Attached)
I want to copy the values for the person with ID number: IG1 from workbookA to the corresponding sheet in workbookB. The sheet for IG1 would be sheet "Test person 1" as cell B1 in this sheet, contains the corresponding ID (IG1).
There are already values in the cells (32, 7 and 1) in WorkbookB (sheet: test person 1), these values should be replaced by 5, 8 and 12 (from WorkbookA), respectively.

This procedure should then continue for the next ID (IG2), and so forth. If the ID is not found in workbookB, it should skip it, and go to the next ID, until there are no more IDs.

So i need a code that compares the ID from column A in WorkbookA, with its corresponding ID, which is located in one of the "Test person" sheets in workbookB, in cell B1. It should then copy and paste the corresponding values (value 1, value 2 and value 3) that matches the ID, from workbookA, to the cells D2, E2 and F2 in workbookB.

Thank you very much!

I'd use ADO.

Please Login or Register  to view this content.

Save both attached to same folder. And while WorkbookA is closed, run code in WorkbookB.

Maybe:

Please Login or Register  to view this content.