Forum Discussion
Cleaning up data with Macros
NikolinoDE gave you the macro you requested.
I want to question your original request. To me--the creator and owner of a spreadsheet that I too use to track income and expenses--your request doesn't make complete sense. If you really are interested in tracking such things, your interest should extend (I would think) to comparing expenses on X in this year with expenses on X in the past year; or quarter to quarter, or ...whatever. The point being, Excel has plenty of capacity to hold data on transactions for many years. I can't understand--which is why I'm asking--why you would want to limit your tracking to only the last three months.
Are you just wanting to make sure each check or credit card charge is accounted for? That could be a legitimate goal, though it wouldn't really qualify as "tracking" in my book. "Tracking," to me, implies an interest in longer term attention to trends in spending in various categories.
So my purpose in asking this is to invite you to a deeper possible goal in your use of Excel.