Forum Discussion
VBA code to identify dates and clear rows
HansVogelaar​ has given you the code you asked for.
I want to take a different tack altogether, and ask you "WHY?"
Why do you want to wipe out history? What does that gain you? Have you thought of what you might be losing in the process?
Now, I'll grant you that most of the time you probably don't care about events or people involved in those events when more than five years has elapsed since the event. However, might there come a time when you would need or want to know? I ask this as the former (I'm now retired for over twenty years) director of a major database for a major corporation. We recorded all kinds of transactions -- i.e., events -- in the database I managed. Most of the time we really only cared about the current or most recent changes. But we never erased the history.
It doesn't really cost you anything (I would submit) to hold on to the history; yes, you'll have rows in there that are old, but unless there's some compelling reason to erase them, I strongly recommend that you keep them. Just in case.
HansVogelaar​ has given you the code you asked for.
I want to take a different tack altogether, and ask you "WHY?"
Why do you want to wipe out history? What does that gain you? Have you thought of what you might be losing in the process?
Now, I'll grant you that most of the time you probably don't care about events or people involved in those events when more than five years has elapsed since the event. However, might there come a time when you would need or want to know? I ask this as the former (I'm now retired for over twenty years) director of a major database for a major corporation. We recorded all kinds of transactions -- i.e., events -- in the database I managed. Most of the time we really only cared about the current or most recent changes. But we never erased the history.
It doesn't really cost you anything (I would submit) to hold on to the history; yes, you'll have rows in there that are old, but unless there's some compelling reason to erase them, I strongly recommend that you keep them. Just in case.
Since posting this I too have been wondering if it's worth the effort. Ultimately my main driver was that I didn't want the spreadsheet to clog up going through rows and rows of data to extract the totals I'm looking for which are only relevant within the last three years. Now that I have a suggested solution, I can see how it goes before making a final decision.
