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

Instead of picture attach a sample workbook

Also confirm whether staff id needs to be matched for Column-C alone or some other columns like column-E will also have the staff id?

Hi Zori,

No problem if you use VLookup. See the attached with the formula of:
=IFERROR(VLOOKUP(A3,$C$1:$D$13,2,FALSE),"")

and then copy it down to the bottom of your data.

Originally Posted by zori2012

Sixthsense, thank u. I attached a sample workbook.

I don't see any special reason for doing it in VBA code since it can be simply arrived using Worksheet Functions.

So please use the solution provided by MarvinP in Post #3