Advance Filter in Multiple sheets
 

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.

Advance Filter in Multiple sheets
 

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

--

Regards,
Nigel




"James8309" wrote in message
...
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.