VBA to select Row based on Cell Value and Filter sheet

[rbone]

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?

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.....

 

[rbone]

I figured out the answer to my question.

Cells.Find(What:="Call Type", After:=ActiveCell, LookIn:=xlFormulas, _
        LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
        MatchCase:=False, SearchFormat:=False).Activate
    ActiveCell.EntireRow.Select
    Selection.AutoFilter Field:=1, Criteria1:= _
        "=Abandoned", Operator:=xlOr, Criteria2:="=Incoming"