I have a spreadsheet where columns K-Q are set up to highlight upcoming and outstanding items via conditional formatting.



I want to remove/hide/filter all rows that don't contain an outstanding item in any of those columns. At the moment I'm filtering each column then copy and pasting to a new table, which is quite time consuming.

While having it all in one table would be good, a way to create a table for each column would be an alternative if easier.

Take a look here.

Attached Files

Outstanding.xlsx (11.9 KB, 21 views)

@confuddled
Hi
please note that current courtesy is not considered offensive on public free forums.
A " Hello" or "thank you" is always appreciated.
Cheers

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post