This file has serviced us for a long time, however we have found a problem that has caused us to look at an edit. We need to add a procedure that will do the following:
1. Check column C, of the MasterList tab for any text that is red.
a. If it finds red text? (usually in a group of 5,6,7 etc? Chgs by the file, may need to add a column and remove dups before looking for red text). After finding one grab the value in column A, and then search, column A of the TemplateLayOut and turn that rows text red also. It will be there in the TemplateLayout tab. MasterList tab, creates TemplateLayOut tab.
b. Search the whole column C in of MasterList until all have been checked, leaving the data intake. MasterList does not have the same amount of rows each time.
c. If it does not find any red text in column C of the MasterList, exit sub and done.
Some additional notes that may assist are that it is a dynamic extract, number of columns and rows are never the same.. (unless you extract the same material number¿) Column C, of MasterList tab is a ValidUntil date and these are no longer being used and we need a way to flag those rows to filter them out.
Need a hand writting this script for VBA.
Please advise and thanks. -R-