Creating multiple (5) drop down lists, all dependent on the selection(s) of the prior

Andrea.Taylor

New Member
Joined
Jul 6, 2010
Messages
4
I need to put together a worksheet that assists users in selecting a valid account for posting activity. Prior to viewing a list of acceptable account numbers (with full descriptions), the user must 1st select from 4 other drop downs.

Column A has 2 possible selections
Column B has 2 possible selections
Column C has 8 possible selections
Column D has 20 possible selections
Column E has 36 possible selections

Column A and B are not dependant on each other
Column C is dependant on the combined selections in Col A and B
Column D is dependant on the combined selections in Col A, B and C
Column E is dependant on the combined selections made in Col A, B, C and D

I've read many posts that reference cascading drop down lists. I have not been able to find a post that 1) addresses having more than 2 dependant lists, nor 2) avoiding the need to create dependent lists (using the Name and Indirect function) for each possible combination

The Data I'm building off of is not static though major changes are not expected to occur often.

I'm pretty lost here. I'd greatly appreciate any help.

Thanks
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Andrea.Taylor

New Member
Joined
Jul 6, 2010
Messages
4
Hi Thanks Vog, I actually already reviewed that link among many others this past weeked. The issue I have with this approach is that I would need to make multiple dependent list for each potential combination. Using a pivot table off my data, this would equate to nearly 100 named lists (exaggerating a bit).

I'm hoping there's a better approach.
 

chy105

New Member
Joined
Jul 9, 2010
Messages
3
Did you find a solution without having to create all the different combinations? I have the same problem.
 

will31

Board Regular
Joined
May 2, 2010
Messages
140
You can adapt this approach to suit your needs.

If you name each of the range as the predessor then it works fine e.g.;

Turkey
Chicken
Pork

Name the dependants to Turkey as Turkey then name the dependants of the dependants as the dependant.

Put =INDIRECT(cell reference for antecedent e.g. c2) into the data validation.
 

Andrea.Taylor

New Member
Joined
Jul 6, 2010
Messages
4
Did you find a solution without having to create all the different combinations? I have the same problem.
No, not yet. I've been searching all over the web in still no answer. If you find something, please let me know
 

Andrea.Taylor

New Member
Joined
Jul 6, 2010
Messages
4
You can adapt this approach to suit your needs.

If you name each of the range as the predessor then it works fine e.g.;

Turkey
Chicken
Pork

Name the dependants to Turkey as Turkey then name the dependants of the dependants as the dependant.

Put =INDIRECT(cell reference for antecedent e.g. c2) into the data validation.
Will31 - it seems like this method is only functional when you have limited lists. Is there a method that can be applied with lists that may contain more than just a few items? I would like to avoide creating a great amount of named lists especially since the data can change over time.
 

bkissick

New Member
Joined
Oct 23, 2009
Messages
32
Just fill dropdowns C,D,E as A and B are filled dynamically? Would seem to be pretty straightforward to do programatically, just attach to a .selected or .changed trigger in each dropdown. What am I missing?
 

Epst13n

New Member
Joined
Dec 20, 2012
Messages
3
Andrea, I was wondering (translated: eagerly hoping) that you had found a solution to this problem as I run into this scenario quite frequently? I also understand that it was posted 4-years ago, so this may not even be much of a memory.
 

Forum statistics

Threads
1,172,011
Messages
5,878,713
Members
433,367
Latest member
mialauren

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top