If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Pivot from multiple sheets
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 |
#2
|
|||
|
|||
Pivot from multiple sheets
Excel 2007 PivotTable
Consolidate multiple tabs. Reverse PT to get flexible PT. With macro. http://c0718892.cdn.cloudfiles.racks.../05_28_10.xlsm |
Thread Tools | |
Display Modes | |
|
|