ExcelBanter - Pivot from multiple sheets

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Pivot from multiple sheets (https://www.excelbanter.com/excel-worksheet-functions/264795-pivot-multiple-sheets.html)

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

Quote:

Originally Posted by Radhakant Panigrahi (Post 956762)

two options,

1) bring all the data from multiple sheet by reformating into single sheet and make a piovt table. this would be easiet task, if all your data exist less than 65K in excel 2003, where as in excel 2007 the count of rows is not an issue.

2)use consolidated ranges as suggested in below url.

http://www.contextures.com/xlPivot08.html

all the best

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