Delete all after a specific date
 

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
--
George

Delete all after a specific date
 

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.

George wrote:

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
--
George

--

Dave Peterson

Delete all after a specific date
 

Thanks very much, that works well.
--
George


"Dave Peterson" wrote:

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.

George wrote:

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
--
George

--

Dave Peterson