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 6:05 pm
Give scenario 1 in this tutorial a bash?
https://m.youtube.com/watch?v=Yv7QBZXEDDc
RM.
Posted : 02/09/2021 6:58 pm