Thread: Array with date range

Good Evening,
I have a report that is downloaded, that reports all the redtags that is generated through out our shop each day. What I need to do is identify which items are my action items, which are on the RedTagReportDescr tab column "O" label DefectSub1. The following action items I need to report are "Program", "Machine", "Machining", & "Perishable Tooling". I would like help building an array which I think would give me the best results. This array would need to look at the date to see if the red tag is from the last 4 weeks. If it is from that time period and had the 4 key words in the DefectSub1 column I would like to out put those instances on to a different sheet, outputting the date, part number, and the description of the problem.

I would also like to build an array on another tab that if the word "deburr" was in the description it would pull that information out on to its own sheet, (see sheet "parts not deburred"

I have attached an excel file called sample. I'm using excel 2007 at work. The file I created in excel 2010 at home.

Thank you for all your help. please ask if there is any additional information.

Chris