I have a pivot table and chart in sheet2, reference Data in sheet1, and I need copy it to sheet3 twice(differen placement).
In Excel I can select the pivot table and chart range and paste to other sheet and will copy al…...and chart in sheet2, reference data in sheet1, and I need copy it...AI answer have not consider source pivot table fields options...