+ Reply to Thread
Results 1 to 4 of 4

Multiple Drop Downs

  1. #1
    Registered User
    Join Date
    12-08-2017
    Location
    Cuba, Mo
    MS-Off Ver
    2010
    Posts
    2

    Multiple Drop Downs

    So I have data imported from a SQL query, the data is like this:

    5105 D1 .03
    5105 D2 .04
    5105D-C A3 .33
    5105CD-C B1 .06


    What I Am wanting is a drop down for the first column. Then based on the results, give me a drop down of all the options for column two, then display at the end after selecting column two is column three. And these are in a huge table, so seperating them into individual named lists would be to much work. So looking for an easier way.

  2. #2
    Registered User
    Join Date
    06-04-2017
    Location
    India
    MS-Off Ver
    2013
    Posts
    54

    Re: Multiple Drop Downs

    Please upload a sample excel file with dummy data

  3. #3
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,560

    Re: Multiple Drop Downs

    Hi and welcome to the forum.

    I can do no better than refer you to Debra's Contextures web site here where you'll learn all you ever need to know about dependent drop down lists - and more.
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  4. #4
    Registered User
    Join Date
    12-08-2017
    Location
    Cuba, Mo
    MS-Off Ver
    2010
    Posts
    2

    Re: Multiple Drop Downs

    5105-c d1 0.03333333
    5105-c2 a1 0.01666666
    5105-c2 c1 0.01666666
    5105-d d1 0.02777777
    5105-d d2 0.03333333
    5105-d2 a1 0.125
    5105-d2 a10 0.02777777
    5105-d2 a11 0.01851851
    5105-d2 a2 0.01388888
    5105-d2 a3 0.05555555
    5105-d2 a4 0.03125
    5105-d2 a5 0.02777777
    5105-d2 a6 0.03125
    5105-d2 a7 0.08333333
    5105-d2 a8 0.025
    5105-d2 a9 0.03125
    5105-d2 c1 0.125
    5105-d2 c10 0.02777777
    5105-d2 c2 0.01388888
    5105-d2 c3 0.05555555
    5105-d2 c4 0.03125
    5105-d2 c5 0.02777777
    5105-d2 c6 0.03125
    5105-d2 c7 0.01388888
    5105-d2 c8 0.025
    5105-d2 c9 0.03125
    5105-d3 a1 0.0625
    5105-d3 a2 0.02777777
    5105-d3 a3 0.02777777
    5105-d3 a4 0.03125
    5105-d3 a5 0.01851851
    5105-d3 c1 0.0625
    5105-d3 c2 0.02777777
    5105-d3 c3 0.02777777
    5105-d3 c4 0.03125
    5105-d3 c5 0.01851851
    5105-d4 a1 0.02777777
    5105-d4 c1 0.02777777
    5105d-c2 a1 0.01388888
    5105d-c2 b1 0.01388888
    5105d-d b1 0.02777777
    5105d-d b2 0.03125
    5105d-d b3 0.02777777
    5105d-d b4 0.02777777
    5105d-d b5 0.02777777
    5105d-d b6 0.03333333
    5105d-d2 b1 0.02777777
    5105d-d2 b2 0.03125
    5105d-d2 b3 0.02777777
    5105d-d3 b1 0.02777777
    5105d-d3 b2 0.03125
    5105d-d3 b3 0.02777777
    5105d-d3 b4 0.02777777
    5105d-d3 b5 0.02777777
    5105d-d3 b6 0.03333333
    5105d-d3 b7 0.03125
    5105d-e a1 0.04166666
    5105d-e a2 0.05
    5105d-e a3 0.06666666
    5105d-e a4 0.03125
    5105d-e b1 0.04166666
    5105d-e b2 0.05
    5105d-e b3 0.06666666
    5105d-e b4 0.03125
    5105d-e c1 0.04166666
    5105d-e c2 0.05
    5105d-e d1 0.04166666
    5105d-e d2 0.05
    5105d-e2 a1 0.04166666
    5105d-e2 a2 0.05
    5105d-e2 a3 0.06666666
    5105d-e2 a4 0.03125
    5105d-e2 b1 0.04166666
    5105d-e2 b2 0.05
    5105d-e2 b3 0.06666666
    5105d-e2 b4 0.03125
    5105d-g a1 0.16666666
    5105d-g b1 0.16666666
    5105d-g c1 0.16666666
    5105d-g d1 0.16666666
    5105d-h a1 0.125
    5105d-h b1 0.125
    5105d-h c1 0.125
    5105d-h d1 0.125
    5105d-h3 a1 0.125
    5105d-h3 b1 0.125
    5105-e2 a1 0.04166666
    5105-e2 a2 0.04166666
    5105-e2 a3 0.03333333
    5105-e2 a4 0.06666666
    5105-e2 a5 0.04166666
    5105-e2 c1 0.04166666
    5105-e2 c2 0.04166666
    5105-e2 c3 0.03333333
    5105-e2 c4 0.06666666
    5105-e2 c5 0.04166666
    5105-e3 a1 0.04166666
    5105-e3 a2 0.04166666
    5105-e3 a3 0.05
    5105-e3 c1 0.04166666
    5105-e3 c2 0.04166666
    5105-e3 c3 0.05

+ 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. Clearing multiple dependent drop downs.
    By CustardSquare in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-22-2014, 09:49 PM
  2. multiple dynamic dependent drop downs
    By atomicrabbit in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-29-2014, 10:54 PM
  3. [SOLVED] Multiple drop downs
    By Treecko in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-30-2013, 07:24 PM
  4. Multiple Drop Downs Validation Checks.
    By Ninjataktikz in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-11-2012, 10:58 PM
  5. Multiple drop dependant drop downs in single cell
    By LittleJerry in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-07-2012, 02:21 PM
  6. Multiple dependant drop downs
    By paconovellino in forum Excel General
    Replies: 11
    Last Post: 05-02-2012, 05:05 PM
  7. Multiple Drop-Downs used as parameters for VLOOKUP
    By JPCrow in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-01-2008, 11:53 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