Morning,

I need some help on this please.

Sheet 1 has data from A1 to AP11000. Sheet 2 has data from A1 to
D28000.
Column A is inventory number in both sheets.

I need to do the following: If the same inventory number exists in
sheet 1 and 2, replace the complete row in sheet 2 with the entry from
sheet 1. If it does not exist in sheet 1, but exists in sheet 2,
leave the entry in sheet 2 alone. Sheet 2 will be the new master
sheet.

Thanks