+ Reply to Thread
Results 1 to 4 of 4

Dependent Nested Dropdowns

  1. #1
    Registered User
    Join Date
    10-03-2012
    Location
    Tampa
    MS-Off Ver
    Excel 2010
    Posts
    13

    Dependent Nested Dropdowns

    Hi Everyone,

    I would like to know if it is possible to create dependent dropdown selections. I have attached a spreadsheet that has two nested dropdowns. What is displayed in the second dropdown is dependent on what was selected in the first dropdown. What I would like to do is carry this dependency several dropdowns further. Basically similar to the folder structure in Windows. Once you select a folder you can only choose the folders within that folder. It needs to go a 4 levels deep. The goal is too choose the product, model, voltage, phase and finally the circuit breaker based on all the previous selections.

    If anyone can tell me how to create the nested, dependent dropdowns it will be greatly appreciated. This forum got some amazing Excel talent so I hope it can be done.

    Thanks in advance to anyone that helps.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: Dependent Nested Dropdowns

    This link will certainly help

  3. #3
    Registered User
    Join Date
    10-03-2012
    Location
    Tampa
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: Dependent Nested Dropdowns

    Thanks for the reply arthurbr however that link only shows two dynamically linked dropdowns. I could not figure out how to nest the third and forth one. This Link might help since it has three dropdowns linked and appears to do what I needed. Hopefully, I can figure it out and thank again for the response.

  4. #4
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: Dependent Nested Dropdowns

    Glad you've found . If you had looked all the way down on the link I gave you, you would have found your answer

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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