You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
Chat Forum
1
Posts
2
Users
0
Reactions
41
Views
Topic starter
Thanks for all the help on my earlier question, which led to me using a pivot table to add up the various categories of expenses.
Now what I want to do is to have a workbook with a sheet for each month, which shows the breakdown of each category. Then at the end have a summary sheet that shows the totals for the financial year by category.
I have tried to do this with the Pivot Table wizard tool but I am not getting much success.
Any tips on using a Pivot Table across multiple worksheets?
Posted : 02/09/2021 5:05 pm
Give scenario 1 in this tutorial a bash?
https://m.youtube.com/watch?v=Yv7QBZXEDDc
RM.
Posted : 02/09/2021 5:58 pm