Home |
Search |
Today's Posts |
#1
|
|||
|
|||
excel- multi level select from a list in excel?
How do you create a chained select list in excel? Chained Selects lets you
"chain" multiple form select lists together so that the selection in a "parent" list can tailor the options available in a "child" list. I want to "chain" three select lists and have prepared options for them. It's just like mapping a three-level folder tree to three select lists, the folders/items at top-level will populate the first select list, and when a top-level folder is selected, its sub-folders/sub-items will populate the second select list, and same goes for the third select list. |
#2
|
|||
|
|||
hide
Perhaps through using dependent Data Validation drop-down lists. See Debra Dalgleish's site for info. http://www.contextures.on.ca/xlDataVal02.html Gord Dibben Excel MVP On Fri, 20 May 2005 11:52:09 -0700, "hide" wrote: How do you create a chained select list in excel? Chained Selects lets you "chain" multiple form select lists together so that the selection in a "parent" list can tailor the options available in a "child" list. I want to "chain" three select lists and have prepared options for them. It's just like mapping a three-level folder tree to three select lists, the folders/items at top-level will populate the first select list, and when a top-level folder is selected, its sub-folders/sub-items will populate the second select list, and same goes for the third select list. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple selections from a drop down list in Excel... | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
Create a cascading list box using Excel | Excel Discussion (Misc queries) | |||
Mouse continues to select after clicking on a cell in excel. | Excel Discussion (Misc queries) | |||
How do I import a Windows Explorer list into Excel? | Excel Discussion (Misc queries) |