Dependent dropdown lists

G

Guest

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
 

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

Data Source for Dropdown Lists 6
Data Validation not working in shared file 4
Dependant Dropdowns - Addition of third list 2
Creating a dropdown list based on selection from a differernt drop 5
Seriously need help with formula 3
cross validation 4
Multiple picture inserts via dropdown lists 2
I'm trying to determine how a series of dropdown lists were creat. 2

Top