Delete all after a specific date

G

George

I have data in columns "A" to "E". How do I delete old data that are two
years old. This would be on a rolling two years.
Thank you
 
D

Dave Peterson

Is one of the columns a date column?

If yes, then select that column
data|filter|autofilter
filter on that column (Custom, is less than Nov 17, 2004 (For today))

Then delete the visible rows.

Personally, I think I'd keep the data--you never know when you'll need it. But
I'd use the filter to hide those rows.
 
G

George

Thanks very much, that works well.
--
George


Dave Peterson said:
Is one of the columns a date column?

If yes, then select that column
data|filter|autofilter
filter on that column (Custom, is less than Nov 17, 2004 (For today))

Then delete the visible rows.

Personally, I think I'd keep the data--you never know when you'll need it. But
I'd use the filter to hide those rows.
Click to expand...
 
Top