stanl
06-19-2007, 03:01 AM
I just inherited a task of setting up an Excel sheet to cover a 4-day Annual meeting where I work. I was given what was created last year - very pretty but I understand a nightmare to update (beaucoup last minute changes)
I decided it might be be efficient to set up a series of validation lists for Staff, day, start, end, task and event on a hidden sheet, then use these to create a Master sheet with validated drop-downs to set up and alter the overall schedule, so an entry might look like
Staff Day Start End Task Event
Bob Day1 7:30AM 9:AM Badge Check Registration
and if Bob can't make it last minute, then assign the task to Joe.
Then I was thinking of 4 sheets, one for each day initially set up on 1/2 hour intervals
7:30 8:00 8:30 9:00 9:30 10:00..............................
Event Registration Session 1 Lunch
Bob Check Badges Check Badges
Mary Register
Ed Register
Tom Kick-off Speech
with everything cleared under the event line, then updated via a Button or macro to fill in the Staff names, and tasks under the appropriate hours per event per day.
I'm hoping there might be a template out there to help with this second part. Would be eternally grateful.: pray2: Stan
I decided it might be be efficient to set up a series of validation lists for Staff, day, start, end, task and event on a hidden sheet, then use these to create a Master sheet with validated drop-downs to set up and alter the overall schedule, so an entry might look like
Staff Day Start End Task Event
Bob Day1 7:30AM 9:AM Badge Check Registration
and if Bob can't make it last minute, then assign the task to Joe.
Then I was thinking of 4 sheets, one for each day initially set up on 1/2 hour intervals
7:30 8:00 8:30 9:00 9:30 10:00..............................
Event Registration Session 1 Lunch
Bob Check Badges Check Badges
Mary Register
Ed Register
Tom Kick-off Speech
with everything cleared under the event line, then updated via a Button or macro to fill in the Staff names, and tasks under the appropriate hours per event per day.
I'm hoping there might be a template out there to help with this second part. Would be eternally grateful.: pray2: Stan