Dependent dropdown lists
 

Hi,
I would like to have 36 dropdown lists with values from 1 to 36 (each). But:
If one number is chosen in one of the dropdowns, this number should not
appear in the other dropdowns anymore. So, if 35 dropdowns have been selected
the last dropdown should only show one more value.

How coud I do this in Excel?

Thanks in advance, AXEL

Dependent dropdown lists
 

Try his link to one of Debra Dalgleish"s pages:

http://www.contextures.com/xlDataVal03.html

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Axel" wrote in message
...
Hi,
I would like to have 36 dropdown lists with values from 1 to 36 (each). But:
If one number is chosen in one of the dropdowns, this number should not
appear in the other dropdowns anymore. So, if 35 dropdowns have been
selected
the last dropdown should only show one more value.

How coud I do this in Excel?

Thanks in advance, AXEL