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!
Bookmarks