tintin1012000
Board Regular
- Joined
- Apr 27, 2011
- Messages
- 237
Looking for vb to cycle through filters /,slicer in a pivot chart in sheet 1.After each seletion change in sheet 1 i need to publish sheet 2 as a static webpage where the name of the webpage is taken from a cell in sheet 2 which i have linked to the pivor in sheet 1.
So basically i have approx 10 different selections in pivot in sheet 1 which will output a chart /dashboard for each one . I have a main page with links to all 10 webpages for navigation.. we have office13
Anyone help with the vba to change pivot and publish cycles.
I can have a predefined list in sheet 1 if that helps
So basically i have approx 10 different selections in pivot in sheet 1 which will output a chart /dashboard for each one . I have a main page with links to all 10 webpages for navigation.. we have office13
Anyone help with the vba to change pivot and publish cycles.
I can have a predefined list in sheet 1 if that helps