+ Reply to Thread
Results 1 to 3 of 3

Multiple Drop Down Selections Leads To...

  1. #1
    Registered User
    Join Date
    09-16-2011
    Location
    Who Knows, Where
    MS-Off Ver
    Excel 2007
    Posts
    14

    Multiple Drop Down Selections Leads To...

    Hello everyone,

    Attached is my spreadsheet with 4 tabs. The "Master" tab holds all of the data. The "Supp" tab contains named ranges for my two drop down list cells in the "Graph" tab. The "View Line Details" will display data from the "Master" tab depending on the criteria selected in the "Graph" tab.

    I have some code written already (in Sheet2 = "Graph") that I received in another post for ONE drop down, but some of the requirements have changed for this project to now include 2 drop downs. Since I have a column in the master data that is a combination of the two drop downs (Combo3 in Master), I even tried referencing that in the code (cell K1 in Graph), but nothing is happening now.

    The caveat for the second drop down in the "Graph" tab ("Service Level" column in Master) is that I want a selection of "Total" to sum both Expedited and Standard values from the master data. I also want to remove the Combo3 column from the Line Details tab.

    Help is much appreciated. Thank you!
    Attached Files Attached Files
    Last edited by exs120; 09-21-2011 at 04:46 PM.

  2. #2
    Registered User
    Join Date
    09-16-2011
    Location
    Who Knows, Where
    MS-Off Ver
    Excel 2007
    Posts
    14

    Re: Multiple Drop Down Selections Leads To...

    Ok, I figured it out partly, but I'm still having trouble with one part.

    In the Graph tab, if I select All Suppliers and then either Standard/Expedited, the data is not populated in the Line Details tab. All Suppliers and Total gives me what I want (everything).

    Attached again is an updated spreadsheet. Thanks for the help!
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    09-16-2011
    Location
    Who Knows, Where
    MS-Off Ver
    Excel 2007
    Posts
    14

    [SOLVED] Multiple Drop Down Selections Leads To...

    Solved it!

+ 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