Okay, this might not be possible but I'll ask anyway....
I have a spreadsheet I use to enter all my finances....there's columns for date, category, and amount. I have another table that totals up the items in each category, giving me my total spending in any given category. What I am trying to do is make it so this table only references spending for the current month, instead of all data entered for all of eternity. I know I could simply start a new file each month, but I was hoping for something more automated.
The closest I have gotten is to filter the spreadsheet to show only current month, but it won't allow further data entry.
Any ideas?
I have a spreadsheet I use to enter all my finances....there's columns for date, category, and amount. I have another table that totals up the items in each category, giving me my total spending in any given category. What I am trying to do is make it so this table only references spending for the current month, instead of all data entered for all of eternity. I know I could simply start a new file each month, but I was hoping for something more automated.
The closest I have gotten is to filter the spreadsheet to show only current month, but it won't allow further data entry.
Any ideas?