Forum Discussion
adding ROWS to the spreadsheet https://templates.office.com/en-us/Business-expense-budget-TM04035489
rosbo1 Quite a fancy template. Lots of colors which are almost painful to the eye. But the good thing is that it uses structured tables. On the Start page they suggest this:
On the 2nd sheet there is a note telling you what to do if you want to add rows.
So, on the Planned, Actual and Variances sheets you can add rows within each of the tables but you have to do that in each of the sheets and the inserted rows have to in the same place.
The template gives you four expanse categories, each with its own table in three separate sheets. Then the Analysis sheet links to these tables. If you would want to add an expense category, you need to create a table for it in each of the sheets in a similar way as the current tables. Then add a row to the analysis table, manually link the correct cells and make sure that the graphs are updated correctly. All in all, quite a lot of work for an otherwise not very useful template. But that's just my personal opinion.
@rosbo1
Did you ever find out how to add a new table to this template. I have the same issue and I know the template is clunky but it's already so established that I have to press on with this template. Please let me know if you found an answer.
I can add rows now prob, but additional tables is the issue.
Thanks!