Hello again MrExcel,
I need to filter reports where the filter Row is in a different row on each report.
The code below has the filter Row in Row 7, another report has it in Row 10, and another has it in Row 5, etc, etc..
Is there a way to have the macro search for "Call Type", select the row and set the filter to show "Abandoned" and "Incoming" only?
This code works for Report 1 but not reports 2, 3, 4, 5.....
I need to filter reports where the filter Row is in a different row on each report.
The code below has the filter Row in Row 7, another report has it in Row 10, and another has it in Row 5, etc, etc..
Is there a way to have the macro search for "Call Type", select the row and set the filter to show "Abandoned" and "Incoming" only?
Code:
Rows("7:7").Select
Selection.AutoFilter
ActiveSheet.Range("$A$7:$S$2365").AutoFilter Field:=1, Criteria1:= _
"=Abandoned", Operator:=xlOr, Criteria2:="=Incoming"
This code works for Report 1 but not reports 2, 3, 4, 5.....