Prev: Reposition comment boxes in 2000
Next: Calculate %
From: Radhakant Panigrahi on 28 May 2010 07:32
hi,

i have the below data and i need to make pivot from multiple sheets.i have
tried to make by selecting multiple consolidation ranges, bbut it is not
giving me the flexibility that is available while doing in a single sheet...
Month Processor Process
Jan Mark Manual
Feb Henry Automatic
Jan Chad Automatic
Mar Mark Automatic
Apr Mark Manual
Jan Chad Automatic
Jan Henry Manual
Apr Henry Manual
Feb Mark Automatic
Mar Chad Manual
Jan Mark Automatic
it gives the belowformat...
Row Process Processor Grand Total
Jan 15 15 30
Feb 6 6 12
Mar 6 6 12
Apr 6 6 12
Total 33 33 66

where as i need the below format...is it possible in making pivot from
multiple sheets
Process Month Chad Henry Mark Grand Total
Automatic Jan 2 1 3
Feb 1 1 2
Mar 1 1
Manual Jan 1 1 2
Mar 1 1
Apr 1 1 2
Total 3 3 5 11

From: Herbert Seidenberg on 29 May 2010 00:20
Excel 2007 PivotTable
Consolidate multiple tabs.
Reverse PT to get flexible PT.
With macro.
http://c0718892.cdn.cloudfiles.rackspacecloud.com/05_28_10.xlsm

 | 
Pages: 1
Prev: Reposition comment boxes in 2000
Next: Calculate %