Results 1 to 3 of 3

Thread: Dynamic Dependent Dropdown List Filter

  1. #1
    Member
    Join Date
    Jun 2013
    Posts
    52
    Rep Power
    12

    Dynamic Dependent Dropdown List Filter

    Ok I think that's How I would explain what my question is. Here is what I have so far but its not anything like the way I wanted it. I created a list on a separate page called "parts catalog" actually several list. Each column had a heading for the range of cells per a tutorial that I found online. I used the =indirect(D7) as the command for the other list. The problem is that I forgot that the part numbers also need to be broken down by type.

    On the sheet
    column "B" = Type
    column "C" = Location
    column "D" = Manufact.
    column "E" = Part #


    The idea is that column B would be chosen first or be copied into the template. This is provided prior to the inspection. It has several dropdown selections "Heat", "Photo", "Ion", Pull ....etc this list can can quite long. As the person goes through and enters information in the next cell they will chose from a large list of manufactuers. "EST_Conv", "EST_Add", Simplex,.....etc. After thisthe part number list should be narrowed or filtered down here is an example


    (B) = Photo (D) = EST_Add (E) = several parts numbers that would be listed.


    So far what I have done is create a list for every combination of (B) and (D)
    Example of list names to be called

    PhotoEST_Add
    PhotoEST_Conv
    PhotoSimplex
    etc........

    With each list is the part numbers associated to that list. I just can not figure out how to get this to work. Currently columns (D) works with Column (E) correctly but I'm not sure how to get Column (B) incorporated into this.

    Any help would be great, also whatever makes it the easiest way to enter information in the future as this list of part numbers will continue to grow as new ones are entered into the system at later times.

    Thanks Hopefully someone can point me in the right way.

  2. #2
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  3. #3
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)

Similar Threads

  1. List of Dates In DropDown Starting From Today()
    By rich_cirillo in forum Excel Help
    Replies: 5
    Last Post: 04-10-2013, 05:58 PM
  2. dropdown lists in headings by using Filter
    By Dane in forum Excel Help
    Replies: 3
    Last Post: 01-24-2013, 11:08 PM
  3. Replies: 5
    Last Post: 11-28-2012, 06:37 PM
  4. Dependent Data Validation (Using Only Formulas)
    By Admin in forum Download Center
    Replies: 2
    Last Post: 10-18-2011, 03:14 PM
  5. Data Validation Dependent Dropdowns
    By Admin in forum Download Center
    Replies: 0
    Last Post: 04-10-2011, 03:34 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •