Distributing an amount of hours from a start date
0
Hi guys,
I'm having some trouble working on a schedule for some of my team members. The idea behind this schedule is that I have a list of people, a list of projects and a start date (an end date as well, but I'm interested in that).
What I need to do is create a calendar with the days on columns and the names on the rows. Then, if one person is allocated to a project, then the cells for the respective days should be filled with a maximum of 7 hours.
I'll attach an example so you can figure out better what I'm talking about.
I hope I can find a solution for this, a macro of some sort.
The file already has a macro for hidding the days until today.
Thanks!
Answers
0
I would create data in a tablelike format (similar to a database). One of the columns would be for Date, and use a Pivot table with the dates across the top and workers in Rows.
Janet