Hello! I believe I am way over-complicating this... I want to filter across all Worksheets for a substring within a cell, but my code only filters for a string. The criteria sub-string is not the only text within the respective cells. Essentially I want to say "If Cell contains value, Filter across all sheets" rather than "If cell equals value, Filter across all sheets". Any Advice?
Sub apply_autofilter_across_worksheets()
Dim xWs As Worksheet
On Error Resume Next
For Each xWs In Worksheets
xWs.Range("A1").AutoFilter 1, "=KTE"
Next
End Sub
Sub apply_autofilter_across_worksheets()
Dim xWs As Worksheet
On Error Resume Next
For Each xWs In Worksheets
xWs.Range("A1").AutoFilter 1, "=KTE"
Next
End Sub