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, 19 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

__________________
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