Automatically delete column once the date in that column has expired

**TAN MICCOLI** · 07-30-2014, 10:08 AM

Have have a excel spreadsheets with 2 columns. One with the employees name and one with the date that their warning expires. I would like the employees name to be automatically removed after the date expires. How do I do this.

**jewelsharma** · 07-30-2014, 09:26 PM

I presume the names are in Column A and the dates are in Column B on Sheet1 then, try the following macro:

Please Login or Register  to view this content.

copy this code to the ThisWorkbook Object and enable macros by default for this workbook. Then this code will run everytime the workbook is opened and will delete all expired rows.
HTH!