Advance Filter in Multiple sheets

[James8309]

Hi,

I have this head hurting problem, if anyone can help me it will be
GREAT!!

I have table of data in multiple sheets containing all same number of
columns and rows but cell containing different data in every sheet.

to give a simple example;

A B
1 a2 b2
2 s2 d2
3 a2 c2
4 f2 z3
5 z3 f5

I know how to use advance filter to filter only a2 in column A.
However, If I have like 50 sheets but different data.
How do I apply the same advance filter condition to every other sheet?

Someone Save me!!!!!! SAve~~~~~~~~~ me


Thank you.

 

[Nigel]

If all sheets the same then loop thru all worksheets and apply filter,
example follows....

Dim wS As Worksheet
For Each wS In Worksheets

With .Range("A2:A5")
' other filter conditions here e.g.
.AdvancedFilter Action:=xlFilterInPlace, Unique:=False
End With

Next wS