pivot table
 

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

--
meihua

Option 1.

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

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

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

thanks
bala

pivot table
 

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

Hope this helps,

Hutch

"meihua" wrote:

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

--
meihua