Multiple Sheets / Pivot

L

lab-guy

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
 
J

Jacob Skaria

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)
 
S

Shane Devenshire

Hi,

Show us the layout of the data on the individual sheets and what you want it
to look like on the summary sheet. You list Psy1 and then 3 Psy? What is
that all about?
 
L

lab-guy

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
 
Top