TracyCurrent4
New Member
- Joined
- May 20, 2021
- Messages
- 6
- Office Version
- 365
- Platform
- Windows
I maintain a spreadsheet I inherited that has about 20 tabs with pivot tables pulling from the same data, looking at it in different ways. We distribute the spreadsheet each month after adding the new financial data from the recently closed month and updating each table to include that new month. Is there a way to update all tabs at once, rather than going into each table, selecting the new month, formatting it, and adding it 20 times?