#1
|
|||
|
|||
How to select multiple criteria from same column?
How can I select multiple criteria from the same column?
The following code works fine for single criteria (I added one line code in red font but it filters only the West region data): Sub FilterRegion() With Sheet1 .AutoFilterMode = False .Range("A2:N2").AutoFilter .Range("A2:N2").AutoFilter Field:=1, Criteria1:="East" .Range("A2:N2").AutoFilter Field:=1, Criteria1:="West" 'How to modify the code here. End With End Sub |
#2
|
|||
|
|||
Do it manually while recording with the macro recorder and have a look at the code it produces.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
I need to count based on multiple criteria in multiple columns | rachaels54 | Excel | 1 | 04-18-2017 03:20 PM |
Sum based on multiple criteria (one of the criteria is not unique) until a threshold is reached. | phillipsdp | Excel | 1 | 11-09-2016 12:53 AM |
Select value from table based on two criteria | gebobs | Excel | 4 | 07-21-2016 08:26 AM |
I need to add multiple values based on multiple criteria in a cell not sure what to do | AUHAMM | Excel | 3 | 10-27-2014 09:11 PM |
Copy Multiple Rows to new workbook when multiple criteria is met. | flds | Excel Programming | 5 | 09-30-2014 09:58 AM |