Forum Discussion
Autofill but skipping three columns
JackReed I understood your intentions, but as an accountant I'm horrified by the schedule and I merely tried to convince you to change your approach. The way you have set-up the report is prone to error and difficult to maintain (as you already experience yourself).
Attached, you'll find an updated file showing what a few structured tables can do with the help of Power Pivot (i.e. the Data Model). It's a very quick-and-dirty example, but I would prefer to work with these. But it's of course up to you to decide how you want to control the budget for your sports club.
Riny_van_Eekelen Don't worry as this project is only for practice give by a professor of mine. I like the pivot table that you made but how am I able to add data from future months as the pivot table is very reluctant to new data
JackReed Just type new expense transactions to the first table. It will expand automatically. Then, press Refresh All on the Data ribbon.