Multiple conditional lists from one choice

May 2, 2011 at 13:38:54
Specs: Windows XP
I would like the following to happen:

User chooses a category in Column A.
Based on category, the settings (Columns B - E) populate with category-specific options or grey out if there are no options.

Choose Category A = all four settings populate with default settings (setting 1 = CAS1O1, setting 2 = CAS2O1, setting 3 = CAS3O1, setting 4 = CAS4O1), but the user can edit using options lists (lists named: CatASetting1, CatASetting2, CatASetting3, CatASetting4).

Choose Category B = Settings 1 and 2 populate with default settings and lists: CatBSetting1, CatBSetting2. other settings grey out and lock

Choose Category C = Settings 1 and 2 grey out and lock. Settings 2 and 3 populate with default settings and lists: CatCSetting3, CatCSetting4

I defined the lists on the "validations" sheet using the name manager.

I have an example file, but I don't see how to attach files here.


See More: Multiple conditional lists from one choice

Report •

#1
May 2, 2011 at 16:33:39
Look here to see how to create Dependent Drop Downs lists:

http://www.contextures.com/xldatava...

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
May 2, 2011 at 16:42:01
Thanks! Unfortunately, unless I'm misunderstanding, this method won't work for what I need to do. I need the selection in column A to determine more than one other list. This only works if the col A choice (ex:fruit) determines the list in Col B only (fruit: apples, oranges, kiwi). When my user chooses a category in Col A, there are multiple settings (columns) that then populate with different lists and different defaults.

Report •

#3
May 2, 2011 at 17:49:07
I may be misunderstanding what you are trying to do, but it is certainly possible to create multiple dependent drop downs, with different values in each, based on a single choice from your "main" drop down.

You just need to be creative with your named ranges so that a single choice in Column A populates the other validation lists correctly.

For example, albeit a simple one...

Create a drop down in A1 which allows the user to chose either A or B.

Now create 4 named ranges, with different data in each range, as follows:

A_One
A_Two
B_One
B_Two

In B1 use Data Validation...List...=INDIRECT(A1 & "_One")
In C1 use Data Validation...List...=INDIRECT(A1 & "_Two")

When A is chosen in A1, B1 will be populated with the data from A_One and C1 will be populated with data from A_Two.

Similarly, when B is chosen in A1, B1 will be populated with the data from B_One and C1 will be populated with data from B_Two.

Expand on this concept for as many dependent drops downs as you need.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question