hi Experts,
Am new to VBA and hope get some help here..
I have worksheet with Pivot table having more than 100 rows and I want to copy only first 5 rows without altering the Grand Total data.
I tried VBA code:
but the problem here is am getting Grand Total for the 5 rows only. Instead I want to retain the Grand Total as it is for the whole list.Please Login or Register to view this content.
Also the Pivot Table rows are dynamic (in the sense rows will be growing or shrinking. Grand Total will not be in same row as in example).
Am attaching sample sheet below:
Table on the left is the Pivot Table with exact data and I want table on the right having top 5 rows with label and no change in Grand Total.
PT.JPG
I really appreciate any help provided.
Regards,
Richa
Bookmarks