Dependent dropdown lists

A

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
 
R

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!
=====================================================

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
 
Top