Creating a Pivot Table using multiple ranges

[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

 

[Ross Culver]

Never mind. I found it:
http://www.dailydoseofexcel.com/archives/2006/10/31/excel-2007-faq-draft/

Thanks, Dick.