Jan 09 2024 08:10 AM
Hello, can you please help me ?
I would like to find ID from workbook 1 collum "B" check :
- if ID exists in workbook 2 collum "B" then replace workbook 2 collum "A", "B", "C", "D" with informations from workbook 1 "A", "B", "C", "D"
- if ID doesn't exists in workbook 2 then create a new row with informations from workbook 1 "A", "B", "C", "D"
- Loop this until last row
(Both workbooks use same collum name for the same items)
Thank you forward for the help ^^
Jan 09 2024 08:27 AM
It seems like you're describing a task related to working with data in two different workbooks (wb1 and wb2). If you want to find a specific ID in workbook 1 (wb1) and replace the values in columns A, B, C, and D with the corresponding values from workbook 2 (wb2), you can follow these steps using Microsoft Excel:
Open both Workbooks:
Identify the ID in Workbook 1:
Switch to Workbook 2:
Identify the Corresponding Values:
Return to Workbook 1:
Replace Values:
OR
Note: Adjust the range and sheet name ([wb2.xlsx]Sheet1) based on your actual workbook and sheet names.
Update Workbook:
Remember to backup your workbooks before making significant changes, and carefully verify the IDs to ensure accurate replacements.
Jan 09 2024 08:31 AM
@Tomsmith1122 hello Tomsmith thank you so much but I would like to do this in Macro for leaning purposes I forgot to say it in the post sorry :(