It's likely possible to recreate the table elsewhere using some combination of IFs, v/hlookups, Offset and Indirect.
I'd probably just go with a helper sheet though with pictures, etc on how to reapply the filter. The standard answer is a macro (covered somewhere in here I think) but it seems that's not an option.
Yep, I have lots of other books with the filter and macro setup, first time looking for an alternative. Formulaic approach would be interesting, will ave a look.
It's likely possible to recreate the table elsewhere using some combination of IFs, v/hlookups, Offset and Indirect.
I'd probably just go with a helper sheet though with pictures, etc on how to reapply the filter. The standard answer is a macro (covered somewhere in here I think) but it seems that's not an option.