+ Reply to Thread
Results 1 to 5 of 5

Select Multiple Items From Validation List

  1. #1
    Registered User
    Join Date
    07-08-2014
    Location
    Los Angeles
    MS-Off Ver
    2010
    Posts
    2

    Select Multiple Items From Validation List

    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.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor Hawkeye16's Avatar
    Join Date
    02-27-2013
    Location
    Holland
    MS-Off Ver
    ├•┤ Pew Pew
    Posts
    441

    Re: Select Multiple Items From Validation List

    Something like this. Not sure why it is not ignoring blanks.

    I just noticed you wanted to be able to select multiple categories, I think this will be more difficult and possibly need a macro or helper tab.
    Last edited by Hawkeye16; 07-08-2014 at 05:48 AM.
    Despite the high cost of living, it remains very popular.

    Don't forget to mark threads SOLVED when you get an answer and rep all the geniouses that helped you today!

  3. #3
    Valued Forum Contributor Hawkeye16's Avatar
    Join Date
    02-27-2013
    Location
    Holland
    MS-Off Ver
    ├•┤ Pew Pew
    Posts
    441

    Re: Select Multiple Items From Validation List

    I found and updated the code from contextures and it now does what you want I believe. Just select something again to take it out of the list.

    edit: It seems from the description from your friend he was trying to make the category be able to select multiple, not the sub category.
    Attached Files Attached Files
    Last edited by Hawkeye16; 07-08-2014 at 07:04 AM. Reason: cleaned up worksheet more - took out blanks

  4. #4
    Registered User
    Join Date
    07-08-2014
    Location
    Los Angeles
    MS-Off Ver
    2010
    Posts
    2

    Thumbs up Re: Select Multiple Items From Validation List

    Thank you so much! It's exactly what I need now. I've been working on this so long and you were able to solve it so quickly I really appreciate it.

  5. #5
    Valued Forum Contributor Hawkeye16's Avatar
    Join Date
    02-27-2013
    Location
    Holland
    MS-Off Ver
    ├•┤ Pew Pew
    Posts
    441

    Re: Select Multiple Items From Validation List

    No problem, glad it works for you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 04-22-2014, 11:03 PM
  2. Select Multiple Items in a List and then Print Those Items
    By dcdoc in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-26-2013, 01:16 PM
  3. Macro to automatically select items in a Data Validation List
    By Mysore in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-25-2012, 03:58 PM
  4. Excel Data Validation - Select Multiple Items - Need to Apply Macro to Multiple Rows
    By kristynroll in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-30-2012, 07:44 PM
  5. select multiple items from a dropdown list
    By Rebecca1 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-17-2006, 03:50 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1