ExcelBanter - Auto Deleting by sorting dates

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Auto Deleting by sorting dates (https://www.excelbanter.com/excel-programming/374131-auto-deleting-sorting-dates.html)

drc

Auto Deleting by sorting dates

If column A is populated by dates with 24 other columns holding data, How can
I delete data after 1 year old by using column A?
Thanks

Dave Peterson

Auto Deleting by sorting dates

Maybe you could apply data|filter|autofilter and show only those dates that are
at least a year old. Then delete those visible rows.

drc wrote:

If column A is populated by dates with 24 other columns holding data, How can
I delete data after 1 year old by using column A?
Thanks

--

Dave Peterson

All times are GMT +1. The time now is 07:22 PM.