Copy the Pivot table from one tab to another tab

Prem1977

New Member
Joined
May 30, 2021
Messages
2
Office Version
  1. 2016
Platform
  1. Windows
Hi Members, I have created 3 different pivots based on Power pivot, named in three different tabs as, Pivot 1, Pivot 2 and Pivot 3 Now i have a Dashboard tab where i have the slicers linked to all three pivots. The SLICER work perfectly as per the selection and the all the three pivots get updated correctly. I have three Radio Buttons which are for Data1, Data 2, Data 3. I need to set something like with the slicer ON, if I select radio button 1 which is Data1 on click of the command button the Pivot 1 with the selected Filters should get open in the Dashboard Sheet. Like that if i have checked Data2 Radio button then Pivot 2 tab Pivot should come in Dashboard tab and like so for Data 3 Radio button from Pivot 3 tab.


Am not able to move. Can anyone help so that it will be a great help
 

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

Prem1977

New Member
Joined
May 30, 2021
Messages
2
Office Version
  1. 2016
Platform
  1. Windows
i got it solved. There are many ways. One of the best way is copy the pivots in sheet where you require and set a macro codes to make them hide when other one is open and so it works. I did
 

Forum statistics

Threads
1,136,283
Messages
5,674,831
Members
419,529
Latest member
TommasoP11

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top