Why is it not possible to have two AutoFiltered arrays on the same page?
When an AF is activated on any of the “internal” criteria, it only sorts the cells defined within the boundaries of the array - leaving everything outside the array unaffected.
Under these circumstances, it seems odd that defining another AF array immediately deactivates the existing AF.
Note that it not only sorts, but also filters - which hides entire rows, not limited by “boundaries of the array”.
Yeah, I hadn’t given that a thought. Interesting to see what could possibly go wrong sorting an arrray with already hidden items within a “different” sort pattern.
But, If the second array was below the first array with clear rows between them then currently, the “upper” array sorts and filters independently of the “lower” array.
You can experiment with several autofilters. Fill in the cells with field names, select the required number of rows, add DataBaseRange (Menu / Data / Define range), set the filter.
I’m getting there.
I now have two Autofilter arrays 4x12 one above the other, both operating independently and It’s easy enough to add rows to the lower array with everything “growing” accordingly. If I then grow the upper array until it reaches the lower array they combine with the second filter row partway down the array. If I then sort on an element in the lower table it sorts everything. I appreciate it’s unreasonable (stupid) of me to allow the two ranges to “merge” but should the system prevent me from being this stupid?
I certainly intend to spend a large part of tomorrow playing with it.
Today is a good day - I learned two things. Thanks