![]() ![]() Copy Pivot Table with Show Report Filter Pages If you just need a copy of the pivot table, you can do the job quickly and easily with the Show Report Filter Pages feature. You can see the sample code on my Contextures site. So, I created a macro that will copy the original sheet, name the copied sheet, and select the pivot item in the copied sheet’s pivot table. Angella wanted the pivot table, and she wanted all the other content too. However, this built-in feature only copies the pivot table to a new sheet – it doesn’t copy any other content from the original sheet. The instructions for using this feature are shown below. I suggested that she use a built-in pivot table feature, which is designed to do that – Show Report Filter Pages. ![]() Last week, Angella emailed me, to ask if there was a way to create a copy of a pivot table, for each item in a report filter. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |