Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 12th 09, 12:52 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2009
Posts: 1
Default 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

  #5   Report Post  
Old June 12th 09, 02:50 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2008
Posts: 4
Default 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   Report Post  
Old June 12th 09, 03:08 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2009
Posts: 143
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking drop down lists to another list locobo81 Excel Discussion (Misc queries) 2 May 15th 09 07:39 PM
Drop Down list predicated on other drop down lists ab-original Excel Worksheet Functions 2 March 3rd 09 09:17 PM
Drop down lists that auto create and then filter the next drop down list [email protected] Excel Worksheet Functions 2 September 30th 07 11:53 AM
how do I use one drop-list to modify another drop-lists options? [email protected] Excel Discussion (Misc queries) 3 September 9th 07 05:46 PM
Drop down lists are displaying end of list, how to make it top? LynnSouthan Excel Worksheet Functions 3 June 22nd 05 08:52 PM


All times are GMT +1. The time now is 10:13 PM.

Powered by vBulletin® Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
Copyright 2004-2022 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017