I have a rather lengthy tracker that I would like to condense based on certain cell's font color.
I need to loop through the whole tracker and find the red colored font cells and move them to another sheet with keeping its column in tact.
I have attached the spreadsheet and an example of what I am looking of on Sheet 2 labeled PO's Not Received. I don't need to keep that exact format on Sheet 2, but I would like the columns to move over with the red text from the first sheet along with site names.