Is there a way to automatically create a pivot table with every sheet in a workbook automatically? In other words, I need a pivot table with column range (fj2:fs300) for every sheet in a workbook. I have 30 workbooks with about 200 sheets in each that is continually updated so I can't do it manually. Thanks for your help.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Pivot table Multiple Consolidation Range Automation
- Thread starter Saratoga
- Start date
Jerry Sullivan
MrExcel MVP
- Joined
- Mar 18, 2010
- Messages
- 8,787
You could create a PivotTable in every sheet using VBA.
If all your PivotTables have the same layout, it might be more efficient to have macro that copies a single "master" pivottable, pastes it on every sheet, then changes the data source to the range fj2:fs300 on the same sheet.
You could use the macro recorder to record the process of doing this manually to give you a start on the code.
If all your PivotTables have the same layout, it might be more efficient to have macro that copies a single "master" pivottable, pastes it on every sheet, then changes the data source to the range fj2:fs300 on the same sheet.
You could use the macro recorder to record the process of doing this manually to give you a start on the code.
Upvote
0
Similar threads
- Question
- Question
