Clear Contents of specific cells if Date has Expired.

[sorensjp]

Hello All,

I'm looking to clear a set of cells on the backend 'ACT_MBR' Sheet if a particular qualification has expired. The Sheet 'WEPS_QUAL_RPT' is a copy the data after running an advanced filter on the 'ACT_MBR' Sheet. Once a member's qualification has passed the expiration date I would like a MACRO I can Assign to button to 'clear contents' all of the dates supporting the expired qualification. I don't know the best way to proceed in this case.

In the attached example file on the 'WEPS_QUAL_RPT' Sheet I have a few fake people with some data. On rows 11 & 12 columns S-Z support the Expiration in Column AA which has an expired qualification. I would like to add a MACRO button to Clear the cells containing the cell data residing on the 'ACT_MBR' Sheet specifically for anyone with an expired qualification. I've a normally hidden Column "D" on the 'WEPS_QUAL_RPT' holding the CREW_ID for each member. The original data is held on the 'ACT_MBR' on columns BU thru CB in this case I have a formula calculating the expiration date in column CC.

The goal is to allow for a human to make to choice to clear all cells between BU thru CB only of the date calculated in CC 'ACT_MBR' Sheet. The 'ACT_MBR' Sheet is normally hidden and the 'WEPS_QUAL_RPT' is where the user is seeing a cleaned filterable version of the data.

Thank you for looking at my request.

V/r,
Jim

The attached file shows a "Run time Error" because I just deleted a couple sheets and a Workbook Protection Module. To unprotect any sheet the Pword in Admin.