Macro to Copy Pivot Table and Paste a Regular Data Table in the Same Position

Hello all,

I am looking for a macro that would copy a pivot table and paste the pivot table values only with the pivot table format (i.e. a regular data table). I want the regular data table to replace the data table in the worksheet, not to be copied to another location.

All I have been able to find thus far is a macro that will copy a pivot table and then paste the values and formatting in another worksheet.

Any help would be hugely appreciated.

Please Login or Register  to view this content.