I need help extending a macro to do one more additional step.
In the sample file, I would to search the MasterList sheet tab for any red text that is in column C, meaning that the CatCode is no longer valid. (its date is < today).
If the values in column C is < today, take the value from column A in that row and delete its corresponding row from the TemplateLayOut sheet tab.
May have to reformat the MasterList sheet tab, so the row only shows once… it can show the same CatCode multiple times.
The goal is to get all the out-of-date items off the TemplateLayOut sheet tab, using the data on the MasterList tab