Apply filter across multiple worksheets

**okkoos** · 12-30-2012, 10:11 AM

Hi
this solution can't run on Excel 2010 only take an effect for first sheet. can any one help me please?

edit:

how can I create common filter for all sheets on Excel 2010 workbook? fist column on all sheets are same name and same type value.
thanks.

**Charles** · 12-30-2012, 02:35 PM

Hi,

Welcome to the forum.
You can manually set the filters in each worksheet.
But, I do not think that's what you want.
Can you provide info as to your request?
A workbook example would help.

**AB33** · 12-30-2012, 03:00 PM

In the attached thread, a solution was provided by the OP. This code loops through all sheets. unless the rest of the code would not do what you are after.

Please Login or Register  to view this content.

**okkoos** · 12-30-2012, 06:42 PM

Hi Charles & AB33,
I could not do it in this video sample with Excel 2010. when I run the macro, this macro take an filter effect for only the first sheet, but rows in other sheets are not filtered.
what is wrong?
can anyone explain this example step-by-step on Excel 2010 please?
thanks.

**Charles** · 12-30-2012, 08:21 PM

Hi,

The code provided should work. I tested it.
I created the worksheets with several names including "Aaron".
If you attach a workbook we may be able to help you better.
I'm including a code that does not use a protection and it too works for me.

Please Login or Register  to view this content.

These code should work with the 2010 version.

**AB33** · 12-31-2012, 02:37 AM

On the attached Video, there are two columns of data in all sheets. The column field is Column "A" and the criteria is "H". There are names in column "A" and are filetred by "H". All names which begin with H are filtered.
I think it is most likely that you are not using, or filtering the right column, but the code loops through all sheets.