Creating a Pivot Table using multiple ranges

's Computer Specifications

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

's Computer Specifications

Never mind. I found it:
http://www.dailydoseofexcel.com/arch...007-faq-draft/

Thanks, Dick.

"Ross Culver" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
creating a pivot table w/ ranges from 2 worksheets	=?Utf-8?B?dGw=?=	Microsoft Excel Misc	1	20th Aug 2005 07:16 PM
Pivot Table-Using Multiple SS's or Ranges?	Jugglertwo	Microsoft Excel Misc	2	5th Feb 2005 04:25 AM
Creating pivot table with multiple ranges in excel	=?Utf-8?B?UGhpbCBQb2xpY2VsbGk=?=	Microsoft Excel Worksheet Functions	2	19th Sep 2004 05:07 PM
Pivot Table from Multiple Ranges	Fabio	Microsoft Excel Misc	4	14th Apr 2004 03:48 PM
Creating a pivot table using all named ranges	excelguru	Microsoft Excel Programming	2	29th Feb 2004 11:21 AM