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

Drop Down Lists - Shrinking the List
 

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

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

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

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

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
|