clah2007
05-21-2015, 09:33 AM
Hello!
I have workbook with 2 sheets, and in the sheet "sheet1" exist a Pivot table with the name PivotTable2.
I need a VBA code to change the source data the pivot to another sheet for example "sheet2"
Thank you for help.
Hugo
I have workbook with 2 sheets, and in the sheet "sheet1" exist a Pivot table with the name PivotTable2.
I need a VBA code to change the source data the pivot to another sheet for example "sheet2"
Thank you for help.
Hugo