I have some macro buttons which filter data on time frames... They are housed in Sheet1 and they filter Sheet2.
An example of one is:
I'd like a combo box in Sheet 1, which contains a drop down list of supplier names. Supplier names are housed as a list in Sheet6 and are selected in Column D of Sheet2.
Is it possible that a supplier can be selected from the combo box, and then one of the time frame buttons is clicked, which applies the time filter but now also filters column D of Sheet2 to the specific supplier?
For this example lets say the supplier list will be:
All
Supplier 1
Supplier 2
Supplier 3
Supplier 4
I may have made this way more complex than I need to, but I'm not sure how to adapt the above code to cater for this additional filter.
Thanks in advance.
also posted here
Bookmarks