+ Reply to Thread
Results 1 to 4 of 4

Multiple Data Validation Lists

  1. #1
    Registered User
    Join Date
    09-27-2012
    Location
    Torrance, CA
    MS-Off Ver
    Excel 2013
    Posts
    75

    Multiple Data Validation Lists

    I'm looking to create quality tracking spreadsheet and need to include multiple dependent drop down lists.

    Essentially, I'm looking to drill down by department...so once the department is selected, that will narrow down the rejection type and machine number...but I don't know how to get past the 2nd level of data validation.

    I've attached an example of the information I would be working with on a daily basis.
    Attached Files Attached Files

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    20,907

    Re: Multiple Data Validation Lists

    Debra Dalgleish explains it very clearly on her web site here:

    http://www.contextures.com/xlDataVal02.html

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    09-27-2012
    Location
    Torrance, CA
    MS-Off Ver
    Excel 2013
    Posts
    75

    Re: Multiple Data Validation Lists

    I have seen this, but I get confused regarding how to make the third drop down list dependent on the results of the first drop down list. It looks like this system flows from 1st list to 2nd and then to the 3rd and so on...

  4. #4
    Registered User
    Join Date
    09-27-2012
    Location
    Torrance, CA
    MS-Off Ver
    Excel 2013
    Posts
    75

    Re: Multiple Data Validation Lists

    oh...nevermind...i just saw the add a third dependent list...stupid me...
    I'm guessing this applies for a fourth as well?

+ 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. [SOLVED] Data Validation Lists Across Multiple Sheets
    By mosswood17 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-29-2013, 08:49 PM
  2. Data validation with multiple lists
    By jon_ak in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-25-2013, 12:51 AM
  3. Multiple dependent Data validation lists
    By edphill in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-01-2013, 08:01 AM
  4. Dynamic data validation using multiple lists
    By Danbot007 in forum Excel General
    Replies: 1
    Last Post: 02-01-2011, 08:30 AM
  5. Dynamic Data Validation multiple lists
    By m1066189 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 06-09-2010, 03:42 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