Follow on Excel Piv...
 

MegaSack DRAW - This year's winner is user - rgwb
We will be in touch

[Closed] Follow on Excel Pivot Table question

1 Posts
2 Users
0 Reactions
48 Views
Posts: 8399
Free Member
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
Posts: 1142
Full Member
 

Give scenario 1 in this tutorial a bash?
https://m.youtube.com/watch?v=Yv7QBZXEDDc
RM.


 
Posted : 02/09/2021 5:58 pm