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!
Bookmarks