filtering multiple spreadsheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have many spreadsheets each for one company of a group.

Currently I filter each spreadsheet at a time when I want to see the
relevant area.

Is there a way to filter each company's spreadsheet with only one action on
the parent company's spreadsheet?

Thank you
 
You can use code to open each workbook and do the filter action.
Or do you have all workbooks open ?

What do you want to do (only view the data)
 
The data is in one workbook in several similar sheets, each company in one
sheet.

In each sheet I have used autofilter, to filter to the areas I want to view.

The problem is that I need to filter each company (i.e. sheet) separately.
Is there a way to filter all the sheets in the workbook with just one action?

Thank you
 
This is a basic example that filter on the first column of the CurrentRegion of A1

Sub Test()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
ws.AutoFilterMode = False
ws.Range("A1").CurrentRegion.AutoFilter Field:=1, Criteria1:="yourfilterword"
Next ws
End Sub


Record a macro when you filter one sheet and look at the code
 
Back
Top