I am hoping I dont have to go into some huge long vba or macro coding to do this. I just need a simple way to say "Hey- this row has a red highlighted cell, so copy that row into the other sheet until it is no longer red"
I have seen tons of code, but nothing has worked for me.
So I have one sheet titled "ST Audit history", and the other titled "Tracking". In the ST Audit history, in colum G starting in row 3 and going down, I have dates that are expired and highlighted in red. I would like the whole row to be copied over to the "Tracking" sheet. If the cell is no longer red in the audit sheet, then i want it to disappear from the tracking sheet. Any ideas? Maybe an "if, then," formula?
Thanks to anyone who can make this simple for me