Forum Discussion
building a Budget spread sheet
teb372020 I'd recommend you to use a Pivot Table on you your transaction listing (Tab: INPUTE FORM). Added some data to your example (Facility J) to demonstrate the principle.
First, I created an Excel Table of the list. Then, I made some Pivot Tables (Tab: PT) from it. One that lets you select the facility. The other has all facilities in one table. Choose whichever works best for you. It took no more than 30 seconds to create. Double-click on a number and a new sheet is created, showing the underlying transactions. When you are done you can delete it, as it can be recreated anytime.
From here, you can easily match the actual spending to your budget.
Thank you I have not use a pivot table before I will look at it Riny_van_Eekelen
I was thinking I should be using the if, or match something like that I will play with it!
teb372020 Good! Pivot tables are great for what you want to do. The help screens can guide you further. If you have anymore questions, come back here.