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.