+ Reply to Thread
Results 1 to 4 of 4

data validation lists that are determined by a previous data validation list selection

  1. #1
    Registered User
    Join Date
    06-04-2015
    Location
    Milwaukee, Wisconsin
    MS-Off Ver
    2013
    Posts
    10

    data validation lists that are determined by a previous data validation list selection

    1) I need there to be a data validation drop down list under each of the headings on sheet 1 based on the information in sheet 2. There are lots of spaces in between some of the entries in sheet 2 as you can see for the different utilities especially. I need the entries to show up in the drop downs without the spaces, as it looks unprofessional to have spaces in there.
    2) I need the drop downs to be dependent upon each other. I.E. the MEASURES drop down needs to list only the measures that are under the selected MEASURE SUB TYPE, the MEASURE SUB TYPE needs to list only the sub types that are under the selected MEASURE TYPE, and so on....
    EX: If utility A is selected from the UTILITY drop down, system types A and B should show up in the drop down of SYSTEM TYPE.
    Then if system type A is chosen from the drop down, sub-system types A,B, and C should show up in the drop down of SUB-SYSTEM TYPE.
    Then if sub-system type A is chosen, measure types A and B should show up in the drop down of MEASURE TYPE.
    Then if measure type B is chosen, measure sub types D and E should show up in the drop down of MEASURE SUB-TYPE.
    Then if measure sub-type E is chosen, measures EDRT, EEE, EGU, EAS, EWQ, and EQET should show up in the drop down of MEASURES.

    Both of these dilemmas are in the spreadsheet as well, so if you open that it should have all the info you need to solve it.

    All of this data can be found in the attached excel 2013 spreadsheet. My apologies for the vague information and data in the sheets. I can't provide much more, due to my workplace wanting me to keep things in house, especially since I am in product development. The spreadsheet is similar to how my actual sheet works, so if someone can show me how to fix these two problems in this sheet, I will be able to do it in my own.

    Thanks in advance for any help or recommendations.
    Attached Files Attached Files

  2. #2
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,880

    Re: data validation lists that are determined by a previous data validation list selection

    Perhaps this will help http://www.contextures.com/xlDataVal02.html

  3. #3
    Registered User
    Join Date
    06-04-2015
    Location
    Milwaukee, Wisconsin
    MS-Off Ver
    2013
    Posts
    10

    Re: data validation lists that are determined by a previous data validation list selection

    Pepe Le Mokko, that doesn't solve dilemma #1 though. I see how that can solve the second one, but the other issue is that I need to be able to update the spreadsheet and have it automatically update the dropdown lists without having blank cells in there with it.

  4. #4
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,880

    Re: data validation lists that are determined by a previous data validation list selection

    Perhaps use Dynamic Named Ranges?

+ 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: 10
    Last Post: 12-19-2014, 07:14 PM
  2. [SOLVED] Data Validation : 2 Lists dependant on selection with vlookup for 3rd value
    By scwillyb in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-26-2014, 02:25 PM
  3. Replies: 3
    Last Post: 10-08-2013, 11:48 AM
  4. Replies: 11
    Last Post: 07-05-2013, 03:19 AM
  5. Replies: 3
    Last Post: 09-02-2010, 03:04 AM

Tags for this Thread

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