My knowledge is pretty basic when it comes to excel and Google Sheets. I'll explain what I'm trying to do.
I'm trying to find a way to filter information from 1 sheet to another in Google Sheets. Ideally, I would like to display an entire row if it is a certain colour. If I can't do it by colour then I'd like to display the row if a certain column within the row says
COMPLETE. I have many rows to sort through so I'd really like a way to do this automatically instead of copy and paste.
Any help is greatly appreciated!