Here is the code I have to filter my data.
However, I want to delete not Hide all the rows (besides headings) that DOES not meet these 2 criteria.
How would I modify this AND the range that changes on a daily basis.
Sub FilterTest3()
' FilterTest3 Macro
' Keyboard Shortcut: Ctrl+p
Range("O2").Select
Selection.AutoFilter
ActiveSheet.Range("$A$1:$S$15").AutoFilter Field:=15, Criteria1:="=MFS*", _
Operator:=xlOr, Criteria2:="=#N/A"
End Sub
However, I want to delete not Hide all the rows (besides headings) that DOES not meet these 2 criteria.
How would I modify this AND the range that changes on a daily basis.
Sub FilterTest3()
' FilterTest3 Macro
' Keyboard Shortcut: Ctrl+p
Range("O2").Select
Selection.AutoFilter
ActiveSheet.Range("$A$1:$S$15").AutoFilter Field:=15, Criteria1:="=MFS*", _
Operator:=xlOr, Criteria2:="=#N/A"
End Sub