Delete multiple rows across multiple sheets containing the same keyword

[kurosaki4d]

I have an excel file that contains around 50 sheets, all sheets have the same columns.
However, i would like to delete the entire rows that contains the same keyword "MARTIN" located in the 6th/last column in all the sheets.
I have tried to select all sheets at once and then delete the rows but it only worked for one sheet.
So if there is a way to do that either through an excel option or vba i'm all ears to suggestions.
Thank you

 

[MARK858]

Assuming that you have header rows in each sheet then maybe...

Sub Filterit()
    Dim sht As Worksheet
    Application.ScreenUpdating = False
    For Each sht In ActiveWorkbook.Worksheets
        With sht.Range("A1:F" & sht.Range("A" & Rows.Count).End(xlUp).Row)
            .AutoFilter 6, "MARTIN"
        
            On Error Resume Next
            .Offset(1).Resize(.Rows.Count - 1).SpecialCells(xlCellTypeVisible).EntireRow.Delete
            On Error GoTo 0
            .AutoFilter
        End With
    Next
    Application.ScreenUpdating = True
End Sub

 

[JLGWhiz]

Is 'MARTIN' a stand alone value or is it embedded in other text?