Results 1 to 22 of 22

Hierarchical Dependent Drop Down List???

Threaded View

  1. #1
    Registered User
    Join Date
    01-05-2016
    Location
    USA
    MS-Off Ver
    2007
    Posts
    20

    Post Hierarchical Dependent Drop Down List???

    So I currently have a great, working dependent drop down list, but I have to continually add new things to the second drop down and I now have at least 1,000 items for each section of my 1st drop down list. If that makes sense.

    Drop Down 1
    I created a table with the headers as the drop down list. There are 32 of these.

    Drop Down 2
    Each item underneath the header is in a drop down dependent on the first selection. Between 500-1500 under each of the headings, but can be separated under a sub-heading. I currently just have a space and then a title to separate the sections. I'd like to add the sub-headers into that drop-down as there are only 12 of those

    What I need is to be able to essentially have sub-headers that appear in the Drop Down 2 dependent on Drop Down 1. And once I select the sub-header it will show the items within the sub-header. I only have around 20 different categories and it would eliminate the searching for the item in Drop Down 2. The only thing is that I do not want the sub-header to appear in the cell what-so-ever and I need to contain it to just those two cells. It should work like any sort of start menu on a PC where you can select/hover over programs and it opens up more selections.
    Last edited by qanjorin; 01-05-2016 at 04:39 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Dependent Drop Down list to autofill next drop down with selective choices
    By MitchellHydro1 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-08-2015, 01:18 PM
  2. Mutiple dependent drop down list with a fallback/default list on error.
    By static in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-12-2014, 06:48 PM
  3. [SOLVED] Dependent Drop down list with DEPENDENT DEFAULT VALUE
    By ginieman in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 10-28-2013, 03:56 AM
  4. [SOLVED] Suppress drop-down list dependent on value chosen in another drop-down list
    By ptmald in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-17-2013, 07:17 PM
  5. [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
  6. [SOLVED] 2nd Drop Down List Dependent on 1st Drop Down List Creation
    By LWABowler in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-21-2012, 03:33 AM
  7. [SOLVED] Dependent Drop down list with DEPENDENT DEFAULT VALUE (e.g. Blank)
    By Waqar Ali in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-26-2012, 06:31 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