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.

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
(E-Mail Removed)



"James8309" <(E-Mail Removed)> wrote in message
news:cf589577-f705-4bbc-a55b-(E-Mail Removed)...
> 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.