Forum Discussion
Pivot table data sources
Hello, I would like to create a pivot table from an excel workbook containing various worksheets. All the worksheets have the same headers. The data in the worksheets is organized by month - one wor...
You can create a pivot table from multiple worksheets with the same headers by consolidating data from each separate worksheet range into a PivotTable on a master worksheet. You can summarize and report results from separate worksheet ranges by assembling them so that you can more easily update and aggregate them.
Here’s how you can create a PivotTable from multiple worksheets with the same headers in Excel:
- Click on the “Insert” tab and “PivotTable”.
- A dialog box will appear now, and you will be asked whether we should create the PivotTable in a new or the same sheet. It is good to use a new sheet option in excel.
- Lastly, check the box “Add this data to the Data Model”.
Here’s an online tutorial that might help you with this.
NikolinoDE Your links are correct, but the numbered list in your post is wrong?
- Thanks for the tip, had overlooked it.