Excel Advance Filter limitation problem???
Posted by Tom Urtis on March 10, 2001 1:16 AM
In an Excel 97 workbook I am trying to advance filter 5 range sets of data that can use the same criteria range. I placed all 5 range sets on one worksheet along with the criteria range (separated by enough rows & columns, etc) and wrote a VB procedure to filter all of them, but only one range set (the fifth one) got filtered. So, 2 questions:
(1) Is this a limitation of Excel, in that only one range per worksheet can be advance filtered, or am I missing something simple here?
(2) If there is such a limitation, then I would place each of the 5 data sets on its own worksheet and filter them individually (no big deal), but then would need to copy those 5 filtered subsets to a single worksheet and I am not sure how to do that either.
This would all be done in VB code.
Any thoughts or wisdom? Thanks in advance.