Greetings,

I have a workbook with 1 pivot table on about 80 tabs. We've added a category to the source data and I have constructed the below macro to loop through and modify the source data for each PT. I think I have this part right...

What I need help with is adding "Category 3" to be the first row label and then set up subtotals so that it will appear for each month (it's going to give me a total revenue and total expense line).

I appreciate any help you can give me, as I really don't want to have to go through each PT by hand.

Please Login or Register  to view this content.