TIP - 41 : Moving of Pivot table - Existing or New worksheet

Moving of Pivot table - Existing or New worksheet

When you want to make a different Pivot Tables based your requirements

Then best way to do this is -

How to use -

Step 1: Create and select the pivot table, then go to Analyze tab

Step 2: Then click on "Move PivotTable"

Step 3: From the dialogue box Move PivotTable, choose an option either “New 

Worksheet” or “Existing Worksheet” based on your requirement

Step 4: Then click on OK