G Guest Nov 17, 2006 #1 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
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 Nov 17, 2006 #2 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.
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 Guest Nov 17, 2006 #3 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...
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...
