Forum Discussion

MicrosoftNewbie121's avatar
MicrosoftNewbie121
Brass Contributor
Jan 09, 2024

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

Resources