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.