Counting total registrations....

[bluegirl]

I have a workbook that has a main sheet listing all registrations fo
various courses. I also have individual course registration sheets.

I would like to achieve a couple of things:

1. I would like to have a sheet that shows the total registrations o
each class and the total each area manager has registered for eac
class. It would look similar to this:

Total
Reg Jones Smith Thomspon Kennedy
Class 1 12 3 4 5 0
Class 2 14 4 2 0 8
Class 3 5 1 1 1 2
Class 4 9 2 2 2 3


2. I would like for the appropriate rows (by the class) t
automatically write to the corresponding worksheet.

Does that make sense

 

[Debra Dalgleish]

Instead of maintaining individual course sheets, keep everything on the
main sheet. You can create a pivot table to summarize the data, and use
an AutoFilter to display registrations for a specific course.

There are instructions for pivot tables in Excel's Help files, and on
Jon Peltier's web site:

http://peltiertech.com/Excel/Pivots/pivotstart.htm

And information on AutoFilter in Help, and on my web site:

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

 

[bluegirl]

ya know.. sometimes you can't see the forest for the trees..


I love pivot tables... I was dealing with a screaming migrane yesterda
and quite frankly, I never even thought of it..

So I get to wear the DUH! hat today...

I am so embarrassed..