Home |
Search |
Today's Posts |
#1
|
|||
|
|||
list boxes
Want to set a drop down box that does not repeat the same value despite that
value appearing in the list more than once. Then once a selection is made from the 1st drop down list, the second drop down box selection criteria changes. ie. table a follows: list 1 list2 commodities oil commodities plastics FX options FX spot FX longcall 1st list would have 2 options: commodities, FX - not repeated. User selects "commodities". Then 2nd drop down list automatically changes to contain only: oil, plastics - as commodities was chosen in the 1st list. Hope there is a way to do this, without setting up separate lists for each possible combination? Thanks, Tony |
#2
|
|||
|
|||
Take a look at Debra Dalgleish's page at:
http://www.contextures.com/xlDataVal13.html Data Validation -Dependent Dropdowns from a Sorted List -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "Tony" wrote in message ... Want to set a drop down box that does not repeat the same value despite that value appearing in the list more than once. Then once a selection is made from the 1st drop down list, the second drop down box selection criteria changes. ie. table a follows: list 1 list2 commodities oil commodities plastics FX options FX spot FX longcall 1st list would have 2 options: commodities, FX - not repeated. User selects "commodities". Then 2nd drop down list automatically changes to contain only: oil, plastics - as commodities was chosen in the 1st list. Hope there is a way to do this, without setting up separate lists for each possible combination? Thanks, Tony |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
list and combo boxes | Excel Worksheet Functions | |||
List boxes, drop down | Excel Discussion (Misc queries) | |||
Creating Drop Down boxes with the List function... | Excel Discussion (Misc queries) | |||
Data Validation list boxes | Excel Discussion (Misc queries) | |||
Using symbols for drop down list boxes? | Excel Worksheet Functions |