You are reading a single comment by @aggi and its replies. Click here to read the full conversation.
  • 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.

About

Avatar for aggi @aggi started