Match Cells with coloum header and then copy the same row

[SKVTS]

Hello All,

I'm looking for VBA for my worksheet to match cell in coloum A with Coloum Header D : I and then copy value Coloum B to the same row as the coloum heder match where :

coloum A is workers name
coloum B is amount
coloum header from D : I is workers name
sample sheet is attached,

thank you for any help,

regards,

[DBY]

Hello
Try the following code in you sample file:

Please Login or Register  to view this content.

Hope this helps.
DBY

[PCI]

With formula in case it is enought
A2 =IF($A2 = D$1,$B2,"")
Copy and drag as needed

[PCI]

With macro and value

Please Login or Register  to view this content.

[SKVTS]

Thanks a lot guys you have solve my problem, two of your code are working, cheers