Hi
Iam trying to find a code to create a table(Excel Table)using data from 2 Pivot tables.
Please suggest the code and also what if I have to add data from more Pivot Tables?
Also suggest if .PivotFields(Sum of Budget").Caption = " Budget" is correct code to change column caption in Pivot table?, as it is giving me an error.
Thank You
Iam trying to find a code to create a table(Excel Table)using data from 2 Pivot tables.
Please suggest the code and also what if I have to add data from more Pivot Tables?
Also suggest if .PivotFields(Sum of Budget").Caption = " Budget" is correct code to change column caption in Pivot table?, as it is giving me an error.
Thank You