VB Code to match data and bring to another sheet.

Hello:

Please refer to attached file.
I have data in Sheet1 which shows Employee Names in row 1 with REG HR and OT HR Column.
Now i have Summary sheet where I will have all employees listed in colunm C as shown.
I need VB Code to bring REG HR and OT HR from Sheet1 into Summary Sheet for Date between cell C2 and C3 and put in respected
cell in column D and E.

Let me know if you have any questions.
Thanks.

R

No VBA needed, formulas Index en match can do


Kind regards
Leo

Hello LeoTaxi and Others:

I need VB Code for the above because it is part of other macro process.
(Next Step is to delete rows with zero in column D. Assume all cells in column D are zero, in this case if i delete rows then all formulas will be deleted and have to manually input the formula..I am hoping this is clear why i need VB Code to perform above).
So would really appreciate if VB Macro is done.

Please let me know if you have any questions.
Thanks.

Riz

Hi AB33:

Thanks for the help...After trying out in my actual worksheet, it seems to malfunction.
Please refer to attached file.
In Summary Sheet "OT" Button is linked to your code.
Have a look at the data which got copied.
Let me know if you have any questions.
Thanks.
Riz

I know the code is very sensitive to moving a single row or column. The code is password protected. I could adjust it on my own book, but I am not sure now which sheet is the source or raw data sheet.

Assuming the source sheet is Final-Semi-MonthlyHrs, try the attached. Let me know if you need adjustment

Hi Riz,
Try the attached.
The code works on the sample attached and is very sensitive to moving a row or column. PM if you change the layout in weeks time.