Filter multiple sheets based on one value

[CHRISTACKLEBERRY]

I have seen similar questions and answers, but I have not been able to replicate the results in my situation. (possibly due to a table vs range)

I have an excel file with multiple sheets. I need to filter 3 of the sheets based on the value I type in cell A1 of SHEET1
Lets call the 3 sheets "BILL", "FRANK", and "PETE"
FRANK and PETE are just ranges with data that gets pasted in daily. BILL is a table that has to be refreshed daily.

The column names I need filtered in all 3 sheets are all called "F#" but are not in the same location on each sheet (column 1, 2, 3, etc.)

Can anyone provide some guidance?

Thanks in advance!

 

[mumps]

Assuming the headers are in row 1, try:

Sub FilterSheets()
    Application.ScreenUpdating = False
    Dim fnd As Range, ws As Worksheet
    For Each ws In Sheets(Array("BILL", "FRANK", "PETE"))
        Set fnd = ws.Rows(1).Find("F#", LookIn:=xlValues, lookat:=xlWhole)
        If Not fnd Is Nothing Then
            ws.Range("A1").AutoFilter fnd.Column, Sheets("Sheet1").Range("A1").Value
        End If
    Next ws
    Application.ScreenUpdating = True
End Sub

 

[CHRISTACKLEBERRY]

YES YES YES!!!
Thank you so much! I was able to use the code you provided and add a button to the file so my team can filter all sheets at once.

And your code is written in a way that I can easily modify it apply to other files.

 

[mumps]

You are very welcome.