Adding a new pivot table using same pivot cache on a new worksheet

**pdalal** · 02-06-2015, 03:59 PM

I have a pivot vba code and I would like to use the same pivot cache to create 2 more pivot tables by adding worksheets in the same workbook.
I can add data fields etc on my own but if someone can help me add the two pivot tables that would be great.
Also if anyone has suggestions on cleaning up this code I would appreciate it.
Thanks !

HTML Code:

**pdalal** · 02-09-2015, 11:49 AM

"Bump no response"

**pdalal** · 02-09-2015, 01:29 PM

"Bump no response"

**:) Sixthsense :)** · 02-10-2015, 12:08 AM

Why don't you use Record Macro and create a New PT using the existing Pivot Cache?

**romperstomper** · 02-10-2015, 05:58 AM

You've already got the basis here:

Please Login or Register  to view this content.

just use a different destination and name for the other two. We can't write the code for you as we have no idea what fields you want where.

Adding a new pivot table using same pivot cache on a new worksheet

LinkBack

Thread Tools

Rate This Thread

Display

Adding a new pivot table using same pivot cache on a new worksheet

Re: Adding a new pivot table using same pivot cache on a new worksheet

Re: Adding a new pivot table using same pivot cache on a new worksheet

Re: Adding a new pivot table using same pivot cache on a new worksheet

Re: Adding a new pivot table using same pivot cache on a new worksheet

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Adding code for pivot cache refresh within an existing function

Pivot Table Cache

Excel 2007 : Pivot Table Cache Problem

Pivot Table Cache

Pivot table cache

Bookmarks

Bookmarks

Posting Permissions