filtering multiple spreadsheets

Y

Yiannos

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
 
R

Ron de Bruin

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)
 
Y

Yiannos

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
 
R

Ron de Bruin

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
 
Top