I am looking for someone to create a code for me that will filter for 2 criteria: be between a time interval (July 19,2011 - july 19, 2012) , and match a list of pump #'s.
First i need it to create an array for the pump list.
Then it has to look through 3 worksheets " North , south , and east". It is looking for dates that are inbetween a certain time interval ( that will be input in a worksheet named "MTBR", then compare to the pump array and if the pump #'s match, failure count goes up by 1 (populated in cell g2 for each worksheet).
it would be greatly appreciated to have someone assist me
I will attach the workbook so its easier to understand.