how do I create a pivot table based on multiple sheets

G

Guest

I have a large amount of data which I need to analyse, unfortunately this is
presented over 2 or 3 sheets. Is there anyway of creating a single pivot
table incorporating all of this data, or linking the sheets in order to do
this? Currently, I am creating a pivot table for each sheet and then
copy/pasting each pivot table into a new sheet and then creating a new pivot
table, however this is long-winded and can only be based on the field in the
original table
 
C

Conrad Carlberg

It might depend on how the underlying data is laid out. In the pivot table
wizard, have a look at the Multiple Consolidation Ranges option, which
_might_ solve your problem.
 

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

Similar Threads

Pivot from all sheets 1
Pasted Pivot Table looks at old sheet 1
Pivot table 5
How do I add extra data to a pivot table? 3
Information for Pivot Table 3
Multiple listboxes to update pivot table? 2
How do I save Pivot Table Data 4
how to partially protect a pivot table based worksheet 8

Top