I want to set up a macro that copy and pastes from Sheet 1 to Sheet 2. This part I can do but I also I need it find the corresponding sku in sheet 2 and paste it in there will the abilitly to repaste if required. I cannot have the sku twice in the one sheet.

Can anybody help with this