I'm fairly handy with excel, but I'm not sure where to begin with this project...
I have one sheet, with a schedule for my employees. There's a start time and an end time for all their shifts (each time in its own cell). there's a rom for every employee and volume for every day (with subcolumns for the in and out times).
Here's what I'm trying to do: I want to create other sheets that will dynamically create "zone charts". there will be a sheet for every day of the week, and for instance on Monday's sheet it will see on the master schedule who's working on Monday and then put there name in the first column. To the right of the names are columns designated for each hour we're open, and I want the cells to be highlighted for all hours that the employee is scheduled to be working.
Thoughts? I'm pretty handy with both basic programming and math, so even just suggestions on a strategy to tackle this would be helpful. Obviously the highlighted cells will be formatted conditionally, but how can I relate the row of hours (on the daily schedules) to the times on the weekly schedule?
Thanks for any thoughts.
I have one sheet, with a schedule for my employees. There's a start time and an end time for all their shifts (each time in its own cell). there's a rom for every employee and volume for every day (with subcolumns for the in and out times).
Here's what I'm trying to do: I want to create other sheets that will dynamically create "zone charts". there will be a sheet for every day of the week, and for instance on Monday's sheet it will see on the master schedule who's working on Monday and then put there name in the first column. To the right of the names are columns designated for each hour we're open, and I want the cells to be highlighted for all hours that the employee is scheduled to be working.
Thoughts? I'm pretty handy with both basic programming and math, so even just suggestions on a strategy to tackle this would be helpful. Obviously the highlighted cells will be formatted conditionally, but how can I relate the row of hours (on the daily schedules) to the times on the weekly schedule?
Thanks for any thoughts.
