Hello,

I have sheet1 and sheet2.

1) There is list of names in Column A of Sheet1
2) There is data of employee and their prod value in Sheet2. Employee name in Column A and prod value in Column G
3) I need VBA which will pick up the Column A from sheet1, find the match in Sheet 2 and copy the prod value in Sheet 1 Column K.

Please assist.

Thanks,
Shiva