Data Validation - Dependent Dropdowns

[MrSteve]

Hello

I hope someone can help me with this.

I have a spreadsheet which uses data validation to create dependent dropdowns.

Currently if you choose a "Keyword" you have a limited list of "Control/Action Name" to choose from.

You can view the attached document to see this.

I used this document to create this data validation: http://www.contextures.com/xlDataVal13.html

The options in column D depend on what was selected in column C.

I need to add options to column E. They should be dependent on the option selected in column D.

So, the user picks something in column C, then picks something in column D, and then picks something in column E.

I am having trouble getting the column D/E validation to work. As column D already has validation from column C, how can I add extra validation to work with column E?

Any help greatly appreciated.

Thanks!

Steve

[Bob Phillips]

Am I reading this correctly, you want to have them dependent right to left not left to right?

[MrSteve]

Thanks for your reply. I would like it to go from left to right.

Currently I select something in C and then have a list of relevant options in D.

I would now like E to contain options relevant to what is selected in D...

Thanks

PS This is a really great forum! Thanks for all the help

[MrSteve]

Does anyone have any idea how I can do this?

Thanks