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!
Answer
Discuss

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

Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login