MrSteve
02-18-2008, 10:20 AM
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
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