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.