Forum Discussion
MicrosoftNewbie121
Jan 09, 2024Brass Contributor
Find & replace: Find ID from wb1 if it exist in wb2 then replace collum A B C D with values from wb1
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 ^^
1 Reply
No RepliesBe the first to reply