Consolidate Pivot Tables/Cache using Excel 2003




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.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question