Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filter Across Multiple Sheets | Excel Worksheet Functions | |||
Excel filter over multiple sheets | Excel Worksheet Functions | |||
How do I advance filter to multiple locations at once? | Excel Worksheet Functions | |||
Advance filter search does not filter an exact match | Excel Programming | |||
FILTER ONE MULTIPLE SHEETS | Excel Worksheet Functions |