Hi All, Its been a while since I've done a macro but the need has risen. I've done some of the basics quite easily but stuck on a little issue. My source table is as such Start of Week Person 09/08/2021 Person A 16/08/2021 Person B 23/08/2021 Person C 30/08/2021 Person D 06/09/2021 Person B 13/09/2021 Person C 20/09/2021 Person A 27/09/2021 Person D I have individual sheets named for each person. Which is in the format below Date Number of Hours 09/08/2021 10/08/2021 11/08/2021 12/08/2021 13/08/2021 14/08/2021 I help with writing a macro that will iterate through the source table, navigate to the relevant sheet for the person and populate 8 hours for the week that they were working. Any pointer on where I can go with this?

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Create Timesheet for multiple persons

Thread starter waxb18
Start date Oct 18, 2021

waxb18

Board Regular

Oct 18, 2021

Hi All,

Its been a while since I've done a macro but the need has risen. I've done some of the basics quite easily but stuck on a little issue.

My source table is as such

Start of Week	Person
09/08/2021	Person A
16/08/2021	Person B
23/08/2021	Person C
30/08/2021	Person D
06/09/2021	Person B
13/09/2021	Person C
20/09/2021	Person A
27/09/2021	Person D

I have individual sheets named for each person. Which is in the format below

Date	Number of Hours
09/08/2021
10/08/2021
11/08/2021
12/08/2021
13/08/2021
14/08/2021

I help with writing a macro that will iterate through the source table, navigate to the relevant sheet for the person and populate 8 hours for the week that they were working.

Any pointer on where I can go with this?