Macro to calculate total number of classes offered each month for each event

Hello,

Can someone please help me finding a Macro.

I am trying to calculate total number of classes offered each month for each event. The way data is collected is we have columns for month, events offered that month and number of classes offered under each specific event. Columns used are event date, event Name and total units.

The way I do it now is,
1) Separate and create new tabs for each month.
2) Create pivot table using event name (row label), event date (column label), and total units (value).
3) Copy paste it special in other tab.
4) Insert column between the event name and the first attendance date and name it "classes".
5) For each event, insert the following formula into the cell in the classes column: =COUNTIF(RANGE,”>0”)
This gives me total number of classes.

Thank you in advance for the help,
Ajang

This creates a new "Month" column on BUHS, and then creates a new pivot table on a new sheet that shows counts for each class for each month.

Please Login or Register  to view this content.