Advanced filter with multiple worksheets

Hello,

I would like to know if it is possible to use advanced filter for more than one worksheet simultaneously.
I'm able to filter and copy data from one worksheet and paste them in another worksheet using named ranges and the code below:

[Range("BASE_1").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Range( _
"FILTER_SELECT"), CopyToRange:=Range("FILTER_PASTE"), Unique:=False]

But the thing is, I need to filter the same information from multiple sheets and paste the results in one specific sheet.
In other words: I need to filter the ranges "BASE_1", "BASE_2", "BASE_3"... and so on, each of these being a selection from different worksheets and paste everything on "FILTER_PASTE".

I'm not sure if I was clear enough, but I would much appreciate if someone could help me find a solution!

Plausible

see this thread to see if it matches similar to what you are trying to do
http://www.excelforum.com/excel-prog...ing-macro.html

Hi,

You might filter the second, and any subsequent, ranges in place and then copy below the previous data thus

Please Login or Register  to view this content.