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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple Sheets / Pivot 1
VBA Filtered Pivot Table Showing "Multiple Values Selected"; Only One Value Selected 0
pivot problem 1
HELP PLEASE: Populate multiple excel rows in access at the same ti 2
Macro to Combine Data from Multiple Sheets with Cell References 4
Custom Reporting Across Sheets 1
Pasting Selections from Multiple Sheets along with their Sheet's Name 2
Copying a Range from Multiple Worksheets 4

Top