Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Drop Down Boxes
I am trying to set up a worksheet for a pipeline report. I need to set up
Conditional Drop Down Boxes that are contingent upon the drop down Choice in a previous Drop Down Box. The problem is that I have to set up more than one Dependent Drop Down Box for the same master Data Validation box. I tried the Contextures website, bu I could not see how to do it with either Dependent Lists, Dynamic Lists, or Sorted Lists. Has anyone found a practical solution for this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Drop Down Boxes
I'm not sure what you need, or what you've tried, but maybe created
named ranges with variations of the main items' names. For example, if the main items are Fruit and Veg, have ranges names FruitList1, FruitList2, VegList1 and VegList2. In the first dependent cell, Allow List, and use the data validation formula: =INDIRECT(A2&"List1") In the second, use: =INDIRECT(A2&"List2") AG Moreno wrote: I am trying to set up a worksheet for a pipeline report. I need to set up Conditional Drop Down Boxes that are contingent upon the drop down Choice in a previous Drop Down Box. The problem is that I have to set up more than one Dependent Drop Down Box for the same master Data Validation box. I tried the Contextures website, bu I could not see how to do it with either Dependent Lists, Dynamic Lists, or Sorted Lists. Has anyone found a practical solution for this? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
drop down boxes | Excel Discussion (Misc queries) | |||
Drop down boxes | Excel Worksheet Functions | |||
Drop down boxes | Excel Discussion (Misc queries) | |||
drop down boxes | Excel Discussion (Misc queries) | |||
Drop Down Boxes | Excel Worksheet Functions |