Hi,
please look at my solution on issue
https://www.msofficeforums.com/excel...ate-lists.html

Would this kind of technique help you (i.e. rows are shown or hidden depending on different conditions, but not filtered, instead shown on another sheet)

Kind regards
Bjorn