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:
Sub ActivateAndSortLastWeek()Sheet2.Range("B:D,L:O,T:U,X:X").EntireColumn.Hidden = True
Dim lr As Long
lr = Sheet2.Range("A" & Rows.Count).End(xlUp).Row
Sheet2.Activate
With Sheet2.Range("A1:X" & lr)
.AutoFilter Field:=1, Criteria1:=xlFilterLastWeek, Operator:=xlFilterDynamic
End With
End Sub
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