Copy/Paste Macro from Sheet2 to Sheet1 based on on another column values

[Amarben]

Hi all, first off thank you in advance for reading and considering to help.

I am looking for assistance on a copy paste macro to copy data from Sheet2 to Sheet1.

the macro must Compare the values of columns C in the 2 sheets and if they are equal: copy/paste the whole row in sheet2

Example: If Sheets(2).rows("C4").Value is equal to Sheets(1).rows("C7").Value then copy/paste data from row 4 of sheet2 (Source) into row 7 of sheet 1 (Destination).

If a value in column C of sheet2 does not exist in sheet1 THEN add a new compatible row at the bottom in sheet1 (add the row of the value that does not exist in sheet1).

Below is a visual representation of what i'm looking for:

That's Sheet1 (SOURCE), Culumn C (Project Code is a unique value)



And This is Sheet2 (Destination), with the same culumns and format



After Running the Macro,
the rows of Sheet1 (Destination) having the same values as column C (Project CODE) of Sheet2 (Source) will be updated (values replaced).
If a value of Column C (Project code) does not exist in sheet1, then add a whole row at the bottom / As in the example below



I have been struggling with this task for a few days, I tried some manipulation and I didn't find the right solution, I would be grateful for your help

 

[Fluff]

Duplicate to: Copy values to new sheet if "Key" does not exist with VBA

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.