Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Shift lists
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Shift lists
See this:
http://contextures.com/xlDataVal03.html Biff "pookie1394" wrote in message ... 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to clear validation lists based on other validation lists | Excel Discussion (Misc queries) | |||
LISTS- adding info without repeat to other lists | Excel Discussion (Misc queries) | |||
Lists referencing lists...is it possible? | Excel Worksheet Functions | |||
Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions | |||
lists from other lists in excel | Excel Worksheet Functions |