I have a main worksheet (REPORT) that contains both the PivotTable (named Results) and a Pivot Chart representing data from the Pivot Table Results. One of the final lines of code invokes the "Show Report Filter Pages" process. (code immediately below)
ActiveSheet.PivotTables ("Results").ShowPages PageField:=Participant
ActiveWindow.ScrollWorkbooktabs Position:=xlLast
All well and good except I need to have the accompaning Chart from the worksheet REPORT appear along with each Pivot Table created on the separate Tabs. As the number of Tabs created will vary, any ideas on how to account for each tab created and to create the needed corresponding Pivot Chart?
Thanks for the view...!
ActiveSheet.PivotTables ("Results").ShowPages PageField:=Participant
ActiveWindow.ScrollWorkbooktabs Position:=xlLast
All well and good except I need to have the accompaning Chart from the worksheet REPORT appear along with each Pivot Table created on the separate Tabs. As the number of Tabs created will vary, any ideas on how to account for each tab created and to create the needed corresponding Pivot Chart?
Thanks for the view...!