Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop Down Lists - Shrinking the List
My problem is as follows: I have 10 cells in a spreadsheet that denote 10
different physical "positions" in a restaurant. I use the same drop down list for each cell, and that list is made up of 10 employee names, so that I may assign a separate employee to each of the 10 positions. What I would like is for the drop down list to only show the names of employees that have not yet been assigned. For instance, for the first position, the drop down list will show all 10 employees available (for example, Employees are A, B, C...J). However, if I choose employee A to work in that first position, then the drop down list for position 2 would show only the remaining 9 available, as yet unpicked, Employees (B, C, ....J). Is this possible |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop Down Lists - Shrinking the List
Thanks for your help, this is perfect.
"Jim Cone" wrote: Debra Dalgleish shows how... http://www.contextures.on.ca/xlDataVal03.html -- Jim Cone Portland, Oregon USA "restaurant Q" <restaurant wrote in message My problem is as follows: I have 10 cells in a spreadsheet that denote 10 different physical "positions" in a restaurant. I use the same drop down list for each cell, and that list is made up of 10 employee names, so that I may assign a separate employee to each of the 10 positions. What I would like is for the drop down list to only show the names of employees that have not yet been assigned. For instance, for the first position, the drop down list will show all 10 employees available (for example, Employees are A, B, C...J). However, if I choose employee A to work in that first position, then the drop down list for position 2 would show only the remaining 9 available, as yet unpicked, Employees (B, C, ....J). Is this possible |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop Down Lists - Shrinking the List
Hi
Debra Dalgleish has the solution for you. http://www.contextures.com/DataValDealers.zip or http://www.contextures.com/DataValHiddenDepend.zip -- Regards Roger Govier "restaurant Q" <restaurant wrote in message ... My problem is as follows: I have 10 cells in a spreadsheet that denote 10 different physical "positions" in a restaurant. I use the same drop down list for each cell, and that list is made up of 10 employee names, so that I may assign a separate employee to each of the 10 positions. What I would like is for the drop down list to only show the names of employees that have not yet been assigned. For instance, for the first position, the drop down list will show all 10 employees available (for example, Employees are A, B, C...J). However, if I choose employee A to work in that first position, then the drop down list for position 2 would show only the remaining 9 available, as yet unpicked, Employees (B, C, ....J). Is this possible |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop Down Lists - Shrinking the List
On Jun 12, 7:52*am, restaurant Q <restaurant
wrote: My problem is as follows: *I have 10 cells in a spreadsheet that denote 10 different physical "positions" in a restaurant. *I use the same drop down list for each cell, and that list is made up of 10 employee names, so that I may assign a separate employee to each of the 10 positions. *What I would like is for the drop down list to only show the names of employees that have not yet been assigned. *For instance, for the first position, the drop down list will show all 10 employees available (for example, Employees are A, B, C...J). *However, if I choose employee A to work in that first position, then the drop down list for position 2 would show only the remaining 9 available, as yet unpicked, Employees (B, C, ....J). *Is this possible I think your answer is found at this site: http://www.contextures.com/xlDataVal03.html |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop Down Lists - Shrinking the List
i try this download and it work very nise. one thing to know is i think
excel have to be in automatic calc mode else it not work right. "restaurant Q" wrote in message ... | Thanks for your help, this is perfect. | | "Jim Cone" wrote: | | | Debra Dalgleish shows how... | http://www.contextures.on.ca/xlDataVal03.html | -- | Jim Cone | Portland, Oregon USA | | | | "restaurant Q" | <restaurant | wrote in message | My problem is as follows: I have 10 cells in a spreadsheet that denote 10 | different physical "positions" in a restaurant. I use the same drop down | list for each cell, and that list is made up of 10 employee names, so that I | may assign a separate employee to each of the 10 positions. What I would | like is for the drop down list to only show the names of employees that have | not yet been assigned. For instance, for the first position, the drop down | list will show all 10 employees available (for example, Employees are A, B, | C...J). However, if I choose employee A to work in that first position, then | the drop down list for position 2 would show only the remaining 9 available, | as yet unpicked, Employees (B, C, ....J). Is this possible | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking drop down lists to another list | Excel Discussion (Misc queries) | |||
Drop Down list predicated on other drop down lists | Excel Worksheet Functions | |||
Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
how do I use one drop-list to modify another drop-lists options? | Excel Discussion (Misc queries) | |||
Drop down lists are displaying end of list, how to make it top? | Excel Worksheet Functions |