Hi, all,
new to Tiller but really enjoying it. Before today, I had been manually tracking budgeting in a spreadsheet I updated weekly.
In the course of my setup, I’m noticing that the monthly and yearly budgets let you set information out multiple years, but the categories tab does not seem to go beyond this year. How do you add multiple years if you wanted to start planning a future year’s budget?
Thanks,
-Eric
It sounds like this is what you need.
Open your Tiller Foundation Template
Navigate to the Categories sheet
Select column E and hold the shift key and then select column P. This assumes that column E is the first month you have set and P is the last month you have set.
Right click and choose “Insert 12 right” to insert 12 blank columns to the right of the current budgeting year’s month columns.
Use the fill handle to pull and fill the contents of the month for the last year into the 12 blank column headers. This should create 12 new budget months. The budget months should be formula driven and look like this =eomonth(E1,0)+1 where E1 in the formula is the previous month’s cell.