M meihua May 1, 2010 #1 I have data on two worksheet and i want to analize data by consolidate them togeter.How can i use pivot table?
I have data on two worksheet and i want to analize data by consolidate them togeter.How can i use pivot table?
B bala_vb May 2, 2010 #2 meihua;950632 said: I have data on two worksheet and i want to analize data by consolidat them togeter.How can i use pivot table? Click to expand... 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
meihua;950632 said: I have data on two worksheet and i want to analize data by consolidat them togeter.How can i use pivot table? Click to expand... 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
T Tom Hutchins May 3, 2010 #3 Debra Dalgleish explains how to do this on her excellent Contextures site: http://www.contextures.com/xlPivot08.html Hope this helps, Hutch
Debra Dalgleish explains how to do this on her excellent Contextures site: http://www.contextures.com/xlPivot08.html Hope this helps, Hutch
