Hello, I have a spreadsheet that I can't get to work after looking at Tutorials on line http://www.contextures.com/excel-vid....html#multiple
My problem is this: I have a sheet with a column with a dropdown list that is labeled "Category" that are music genres. The next column is labeled "SubCategory." What I'd like to do is select a Category from the dropdown list. Then, depending, on what I choose in the Category dropdown, I have different options in the SubCategory dropdown. For example:
If I choose ROCK under "Category" dropdown list, my choices for "Subcategory" dropdown list would be: Adult Contemporary, Alternative
Blues, Classic, Folk, Hard, etc.
And if I were to choose RnB under "Category" dropdown list, my choices for "Subcategory" dropdown list would be: Adult Contemporary, Dance, Motown and Soul.
And so on with every Category list validated with a SubCategory list.
ALSO, the SubCategory list should also be able to "Select Multiple Items from Validation List." e.g. If I choose ROCk under Category, I want to be able to Choose Alternative AND Hard in the Subcategory field.
If anyone could point me in the right direction as to what terms to look up or how to accomplish this (or if it's not possible), that would be great. I asked a friend of mine who works with Excel sheets and he wrote back: "I copied and pasted the code into your template and then changed the delimiter from a comma to a pipe ("|"), but that they screws up your conditional validation for your subcategory, since now the indirect formula no longer works due to multiple values in the Category column."Attached is the file I'm working on.
Bookmarks