pivot table

[meihua]

I have data on two worksheet and i want to analize data by consolidate them
togeter.How can i use pivot table?

 

[bala_vb]

I have data on two worksheet and i want to analize data by consolidat
them
togeter.How can i use pivot table?

Option 1.

Yes, you can use mutliple sheets connected to single pivot.

choose, Multiple consolidation ranges option in Pivot table and Pivo
Chart Wizard - step 1 of 3.

Option 2.
It is better to get the all data into single sheet and use pivot.

thanks
bal

 

[Tom Hutchins]

Debra Dalgleish explains how to do this on her excellent Contextures site:
http://www.contextures.com/xlPivot08.html

Hope this helps,

Hutch