ItalianPlatinum
Well-known Member
- Joined
- Mar 23, 2017
- Messages
- 880
- Office Version
- 365
- 2019
- Platform
- Windows
Hello,
I have an excel workbook with over 50 sheets. 1 for each month and growing for each month. Each sheet contains my monthly expenses. I am looking for a pivot table to encompass every tab (same formatting) to give me a summary of what store/expenses. I assumed pivot table was the best route but now having issues finding a way to include all sheets and each month adding one additional. Any help would be great on this I am driving myself nuts. Thanks.
I have an excel workbook with over 50 sheets. 1 for each month and growing for each month. Each sheet contains my monthly expenses. I am looking for a pivot table to encompass every tab (same formatting) to give me a summary of what store/expenses. I assumed pivot table was the best route but now having issues finding a way to include all sheets and each month adding one additional. Any help would be great on this I am driving myself nuts. Thanks.