Multiple Sheets / Pivot

[lab-guy]

Have read about 3D functions here, very helpful. Thanks to all who respond.

I'd like 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.

It's not a sum, or a count. Is there a function for this ?

Thanks

MK

 

[Roger Govier]

Hi

I don't know what else you intend putting on each sheet, but I think you
will save yourself a lot of future pain by putting all the data on one
sheet, with one extra column for Student name (in place of the individual
sheet).

You could then use Filters (for Period 1) for example to bring up a list of
the Students and their discipline.
Alternatively, if the data were set up on one sheet in a suitable manner, a
Pivot Table could be produced.

You will not achieve a Pivot Table from multiple sheets in the manner you
describe.