1) On the Wty Htg sheet, if the part description in column G contains one of the following strings, then the Group ID (Column Y) should always be "T". Here are the strings: Wblu; Worg; Wprp; Wwht; Ctgt; Wred; Wgrn. 2) On the coversheet, Column F should only show the parts missing if there is a "M" in Column AR of the OORPT1 tab.
I'm guessing you will have to create another "Select Case" requiring a "M" in Column AR.
8 freelancers are bidding on average $93 for this job
Dear sir I am very familiar with Excel and have a great experience in this field. I am sure that I can give you perfect result in a reasonable time I will be glad if you contact me Thank you