drop down data?

[scheduler]

I'am trying to set a multiple shift weekly work schedule for 55 employees.I
thought drop downs for each employee and for each day, with the drop downs
containg all shift times would work the easiest to quickly set up schedule.
Having trouble setting up, need step by step if possible

 

[Paul B]

scheduler, have a look here
http://www.contextures.com/xlDataVal01.html

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003