VBA Code for Previous dates

this should work with any range, to use the search range and current date are the same, but the criteria range is the range of all criteria (in your workbook it is range F4:F42), criteria is either typed ie "Active Client" or a range F9

criteria range can only be one column wide

HTML Code: 

Still didn't work..Not knowing how to work with Macros, makes this really difficult. Thanks anyway.