How to Divide Excel Pivot Table Data Into Separate Spreadsheets Within the Same Workbook

1. Click on the worksheet in the Excel file that contains the Pivot Table. You can do this by clicking the appropriate worksheet tab at the bottom of the spreadsheet window.
2. View the Pivot Table and identify the summary calculations along its right side. Pivot Tables can create many different types of calculations, but all are based on the groups indicated in the Pivot Table, and the results of these calculations appear to the right of each group's row.
3. Double-click a result calculation in a single row of the Pivot Table. All the records from the original spreadsheet that comprise that Pivot Table group are instantly copied and pasted into a new spreadsheet in the same workbook. The column headers remain intact.
4. Click back to the worksheet that contains the Pivot Table.
5. Double-click the result calculations for each of the other rows in the Pivot Table, using this same process. Excel creates a new spreadsheet for each group. You will have to click back to the Pivot Table worksheet after creating each spreadsheet so you can move on to the next row. Since the Pivot Table contains groups that summarize all the original spreadsheet data, the entire data source is divided into separate spreadsheets after you finish this process.
6. Click the worksheet tabs at the bottom of the Excel window to view the different spreadsheets in this workbook.