wizau
New Member
- Joined
- Apr 1, 2014
- Messages
- 10
- Office Version
- 2021
- Platform
- Windows
Hello friends,
I'm having trouble with something I just can't seem to sort out, but in my mind should be really easy.
I have a simple table with columns of 2 hour time periods (0900-1100, 1100-1300, 1300-1500, etc) and rows of duties or tasks. For each cell in the table I have Data Validation of a List (pull down list) that refers to a named (array?) of peoples names in another list ("Volunteer##" for now). To assign someone to each task in the rows for that 2 hour time period, you pull down the list and select who is rostered to do that job for those two hours. Not all volunteers have the skills to perform every task, so we have to individually pick the people we know who can do it. All duties have to be "manned" at all times, there can be no blank spaces in this table.
Duty Roster
Now I would like to create a Pivot table style report for each person so they can easily see what tasks they are doing a what time, and what time they have off. But it's just not working, in that no Pivot Table I seem to construct allows me to display by the staff name, what tasks they have assigned them. I am FAILING!
Can anyone help me if this can be done? This is an example of what the result I am after might look like. (This data does not match the data above, it's just an example of the layout!)
I'm having trouble with something I just can't seem to sort out, but in my mind should be really easy.
I have a simple table with columns of 2 hour time periods (0900-1100, 1100-1300, 1300-1500, etc) and rows of duties or tasks. For each cell in the table I have Data Validation of a List (pull down list) that refers to a named (array?) of peoples names in another list ("Volunteer##" for now). To assign someone to each task in the rows for that 2 hour time period, you pull down the list and select who is rostered to do that job for those two hours. Not all volunteers have the skills to perform every task, so we have to individually pick the people we know who can do it. All duties have to be "manned" at all times, there can be no blank spaces in this table.
Duty Roster
Now I would like to create a Pivot table style report for each person so they can easily see what tasks they are doing a what time, and what time they have off. But it's just not working, in that no Pivot Table I seem to construct allows me to display by the staff name, what tasks they have assigned them. I am FAILING!
Can anyone help me if this can be done? This is an example of what the result I am after might look like. (This data does not match the data above, it's just an example of the layout!)
Last edited:
