how do I create a pivot table based on multiple sheets

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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.
 
Back
Top