Follow on Excel Piv...
 

  You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more

[Closed] Follow on Excel Pivot Table question

1 Posts
2 Users
0 Reactions
41 Views
Posts: 8306
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

6 DAYS LEFT
We are currently at 95% of our target!