PDA

View Full Version : VBA change data source Pivot Table



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