+ Reply to Thread
Results 1 to 3 of 3

Dependent Drop Down Lists

  1. #1
    Registered User
    Join Date
    07-06-2021
    Location
    Australia
    MS-Off Ver
    Version 2104
    Posts
    9

    Dependent Drop Down Lists

    Hello all!

    I'm currently working on a spreadsheet to track training data, and one thing I'd like to add is a dependent drop down list for the training provider. It would have a drop-down list in Column J to select the "Provider Type" (either external or internal), then drop-down list column K to select the provider based on whether it's internal or external.

    For the life of me I can't get this to work and I'm not sure why, the drop down arrow comes up in column K but the list won't open.

    I've set up the data for other drop-down lists as named ranges, and added formulas to make them dynamic (so that if anyone adds more providers it will automatically update this in the drop down options). The data for these lists are also kept on a separate tab called "Column Filters". Not sure if either of these factors may also affect what I'm doing?

    I'll attach screenshots showing the current set up, any help would be greatly appreciated!

    Drop Down List - Provider Type.pngData Validation - Provider Type.pngData Validation - Provider.pngNamed Ranges.png

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Dependent Drop Down Lists

    See if you can adapt the attached sample file to suite your needs.

    Dependent DD's are based on named ranges. Each level has a set of named ranges, and each "item" within a level becomes the named range for that category.
    Attached Files Attached Files
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Expert
    Join Date
    09-30-2019
    Location
    Chiangmai, Thailand
    MS-Off Ver
    Office 2016, Excel 2019
    Posts
    1,234

    Re: Dependent Drop Down Lists

    This is another way of related dropdown, it's not use name ranges but need unique key to operate.


    Regards.


    Note : If your category is static, name range is much more better.
    Attached Files Attached Files

+ 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: 11
    Last Post: 10-08-2021, 04:55 AM
  2. Replies: 4
    Last Post: 01-27-2020, 09:32 AM
  3. [SOLVED] Clear up to three dependent drop down lists based on selection in superior drop down list
    By theletterh in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-04-2016, 09:31 PM
  4. Dependent drop down lists without creating unique named lists
    By pajordan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-11-2013, 12:20 PM
  5. dependent drop down lists
    By scorry in forum Excel General
    Replies: 1
    Last Post: 06-26-2013, 07:55 AM
  6. [SOLVED] Column B drop down list with 2 options, columns C & E with dependent drop down lists
    By betic in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-26-2012, 03:47 PM
  7. Dependent Drop Down lists (multiple drop down)
    By jijy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-17-2007, 09:56 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