Thank You.

I added 4 ranges and it worked for 4 sheets.

Possible to do as a 3D, to get all sheets in workbook ?

MK

"Jacob Skaria" wrote:

From 'PivotTable and PivotChart Wizard -Step1 of 3' window select
'Multiple consolidatation ranges'

From 'PivotTable and PivotChart Wizard -Step2b of 3' window select add the
ranges from multiple sheets.

Please make sure the data format is same in all sheets.This should work...


JacobSkaria
(If this post is helpful please click Yes)


"lab-guy" wrote:


I posted this to Excel formulas, but something tells me its more than that.

I have 1 sheet for every student. with a class code (PSY1, ENG2) in the
same cell in every worksheet. I'd like a summary sheet that shows for
period 1,
I have 3 PSY, 2 ENG, 5 HIST, etc.. i.e. a little pivot table.

Any ideas ?

Thanks

MK