VB Code to reorganize data..

Hello:

Please refer to attached file.

I have ClockIn-Out data as shown in Sheet1.
I need to reorganize the data.
Below is what i need to accomplise.
I have created Unique Employee list in column A in Sheet2.

I need VB Code to look up data for 1st Employee in Cell C5 in Sheet2 and depending on the day and date,
add hours worked on particular day from column E Sheet1 into corresponding cell in range H4:N56.


Let me know if you have any questions.
Thanks.
Riz

Hello:

It would be ok if this can be done thru formula also.
Please let me know if you have any questions.
Thanks.

Riz

Maybe :

Please Login or Register  to view this content.

Hi Karedog:

Thanks a lot..it works and it needs little tweaking for my requirement.
Please refer to attached excel file and pdf flowchart.
I need to use the code for all employees in column A and create pdf for each employee.
Your code and my pdf code works great but it crashes after 1 employee's pdf file is created.
Also need total which becomes zero, although i had formula in Total column to add Mon-Sun hours.
Below is my pdf code which works:

Please Login or Register  to view this content.

Let me know if you have any questions.
Thanks.

Riz

Hi Karedog:

Attached is the error in the code when i loop from A5 to A48.
Please let me know if you have any questions.
Thanks.

Riz

You are welcome.

Please Login or Register  to view this content.

Sub Master is the one that you must run (sub Worker will be called from sub Master).

Hi Karedog:

Great work....little correction needed.
Need to set PDF Page Zoom to 90% and Margin to as attached pic.
This is make it to print on one single page....currently it is printing on 4 pages.
Have a look at attached pdf which prints on single page.
Also would add current year (2016) in front of pdf File Name.
So basically File name would be 2016_EmployeeName.
Please let me know if you have any questions.
Thanks.

Riz

Please replace the sub Master() with this code :

Please Login or Register  to view this content.