Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
dropdown lists | Excel Worksheet Functions | |||
How to refresh dropdown lists in PivotTables? | Excel Discussion (Misc queries) | |||
dependent dropdown | Excel Discussion (Misc queries) | |||
Dropdown lists | Excel Discussion (Misc queries) |