Copy columns from one table to another if

[Phleacia]

First off... I'm very very new to VBA and I could use some help.


I have two worksheets one with old data "Share" and one with new "SAP". I'm trying to create a macro to sort of syncronize the two. I want the rows in the "SAP" sheet that do not exist in the "Share" Sheet to copy from the "SAP" Sheet to the "Share" Sheet under the existing rows.

Rows that exist in the "Share" sheet I only want the macro to copy over from the "SAP" sheet specific columns (A2- "Assigned To" and I2 "Release indicator") to the rows that have the same "Rec Item", Column K in Share sheet and Column O in SAP sheet.

I have a macro in place now when run gets the last column "Action" Column Q to identify whether each row is New with the text "NEW", No change "NC", or Changed "CC". But I'm not sure where to go from there.....