find duplicates in A and C columns, copy D column content of C duplicate's row to A's B ?

Sorry for my stupid title. I have no knowledge of vba, though I was able to execute VBA commands advised from this forum, for which I thank a lot.

Is there a way to find duplicates in different columns or sheets (for example: staff id, in A and C column), then copy what is in the right column of C column duplicate's row (i.e. work hour) and paste it to the right of the duplicate in A column? When this is done, I will delete C and D column. This continues for 1000's of rows. The same process is going to applied to other performance indicators of staff. Thank you all in advance, for your feedback.

before1.png

after.png

final.png

Book3.xlsx