Hi. I've included a small portion of an excel sheet that I build every day for a user. Rows of data are grouped by an M-number. Each M-number consists of a number of operations (OPSEQ) and I'm changing the font color where an operation is started before the previous operation is reported complete. I found out my user only wants to see an entire M-Number grouping (All operations for an M-number) where the font color is blue or red on one of the operations and he has been manually deleting groupings of rows he does not want to see.
I'm thinking there has to be a way to handle this through programming but I can't wrap my head around this. Any ideas are welcome. either delete unnecessary rows or move necessary rows to another sheet?