I am using Office 2003 and I have a calendar in Excel. Each day is divided
into 2 cells. The upper cell is 2nd shift, the lower cell is late shift. I
created dropdown lists for each cell to choose from that is populated with
the names of those scheduled. That's Monday thru Thursday. For Friday, those
that weren't scheduled for the week, could be chosen to work Friday late
shift, the only shift for the day that is scheduled. I've been manually
creating the list, but was wondering if there is a way that would
automatically create a list containing the names of those who weren't
selected for shifts on the previous days.

Thanks!