Consolidate Pivot Tables/Cache using Excel 2003

's Computer Specifications

Hi,

I have an Excel 2003 workbook with 20 worksheets. Each worksheet contains
one Pivot table.The Pivot tables all have a common structure and the same
number of fields. Is there a way to consolidate the individual Pivot tables
into one master Pivot table using VBA? Alternatively would it be possible to
use VBA to cycle through all the underlying Pivot Caches and copy all the
data to a new worksheet?

Any help/guidance appreciated.

's Computer Specifications

hi,

you could do a query on PivotTables sources

--
isabelle

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
consolidate charts from multiple pivot tables	Nicawette	Microsoft Excel Charting	0	12th Feb 2010 02:10 PM
Consolidate information from multiple pivot tables	Clare	Microsoft Excel Worksheet Functions	2	15th Jan 2009 05:52 PM
How do I consolidate 2 tables into 1 pivot report?	=?Utf-8?B?RGViLXRhc2hh?=	Microsoft Excel Misc	2	5th Oct 2006 08:09 AM
Consolidate Pivot Tables	=?Utf-8?B?SlM=?=	Microsoft Excel Misc	1	30th Jun 2006 07:45 PM
how do I consolidate multiple pivot tables into one pivot table?	=?Utf-8?B?cGthaG0=?=	Microsoft Excel Misc	0	20th Apr 2006 09:48 PM