Creating a Pivot Table using multiple ranges

  • Thread starter Thread starter Ross Culver
  • Start date Start date
R

Ross Culver

Using Excel 2007, how do you create a pivot table using multiple ranges?
The option does not appear in the Create Pivot Table wizard.

I thought I could use something like this: 'Page 1'!$A$6:$T$28805:'Page
2'!$A$6:$T$28805 ; but it wasn't accepted as a valid range.

Thanks,

Ross
 
Back
Top