Drop down list - how doo I make selection disapear?

T

Tore

I have a drop down list, with 16 names, and also 16 cells where the same drop
down list is displayed. What I want is this:

When e.g. the name "Ann" is selected in one of the cells (based on the drop
down list) I want "Ann" to disappear from all of the other drop down lists.
This to ensure that one name can only be selected once, and to make sure that
all names are selected at least once.

How do I do that?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtered drop down list 2
drop down list should remember selection. 6
How do I auto populate based on a drop down list? 0
Linking drop down lists to another list 4
Conditional Drop Down List 1
Drop-Down List 3
Change drop down list in one cell based on values in other cells 2
How can I add to a drop down list after I have selected it? 4

Top