Dependent dropdown lists

[Axel]

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

[RagDyeR]

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" <[email protected]> wrote in message
news:[email protected]...
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