I am able to use the Excel Pivot function (under "Options") of pasting a new pivot table into a new sheet based on the Filter in my pivot table. However, the pivot table will only paste in cell A1 of each new worksheet. I'm trying to figure out how I can have it pasted in a different cell in each worksheet. I can try using the below VBA:
Set pvtTable = Worksheets("Sheet1").Range("A3").PivotTable pvtTable.ShowPages "Country"
A few questions on the above:
- "Sheet 1" is the worksheet where the original pivot table is?
- "A3" is the cell for the original pivot table? Which cell of the pivot table should go in here?
- "Country" - that's just the filter I would like to use which each new pivot will be filtered by?
Also, what would be the syntax to specify the cell to paste each new pivot?
Thank you!
Set pvtTable = Worksheets("Sheet1").Range("A3").PivotTable pvtTable.ShowPages "Country"
A few questions on the above:
- "Sheet 1" is the worksheet where the original pivot table is?
- "A3" is the cell for the original pivot table? Which cell of the pivot table should go in here?
- "Country" - that's just the filter I would like to use which each new pivot will be filtered by?
Also, what would be the syntax to specify the cell to paste each new pivot?
Thank you!
