can i use more than one worksheet in a pivot table ?

[Klutzz]

Is there a way to incorporate data from 2 worksheets into a single pivot
table??

thanxx,

klutzz

[rsenn]

Yes.

Get there by Data > Pivot Table and Pivot Chart Report > Multiple Consolidation Ranges

[Debra Dalgleish]

You can create a pivot table from data on separate sheets (multiple
consolidation ranges), but the results may not be exactly what you want.
There's more information here:


http://www.contextures.com/xlPivot08.html


Klutzz wrote:
> Is there a way to incorporate data from 2 worksheets into a single pivot
> table??
>
> thanxx,
>
> klutzz


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html