Excel automations

[cabrzama]

I am trying to figure out if there is a way to automate grand totals that are autofiltered and then create a PDF report of it.

Background: I oversee a small continuing education program for about 200 students. I put their class attendance info. (including dates, hours earned, class names, etc.) into a worksheet that has the auto filters setup for each column so that I can filter by name, class, date, etc.). However, the next step is to provide a report to each of the 200 participants periodically, without having to manually (auto sum) total up the number of hours each person has earned and then create a PDF of it, which would take lots more time. Is there a solution out there that would automate those two things for me or at least one of them?

I've uploaded a sample file. Thanks!

[Chance2]

You could use the SUBTOTAL function to get your grand total by filter:

=SUBTOTAL(9,I2:I13)

As for the PDF, that would require a macro (VBA code).
If you are not familiar with VBA, then you could record a macro of saving as a pdf and then cycle through your drop down.