I have a Pivot table and am trying to find a solution to copy the contents of the pivot table into a new sheet. I just need the values that is generated for the particular filter - Nothing else. In the sample attached, I need to copy the values in the yellow region to a new sheet.
Manual copy/paste is easy, but I am looking to automate this process. The value might change in the pivot table based on updated values and so on, but when the macro is run, the pivot table has to be chosen and all its values have to be copied into a new sheet.
Is this possible?
Bookmarks