Report One Quarter at a Time

Copper Contributor

I have an Excel workbook with volunteer hours.  We have names down the left side and the hours per week/per quarter in the cells with totals by quarter.  I need to be able to print the workbook out one quarter at a time.  I need to automate the report because we have people who aren't very good with Excel that use the reports.  How do I do that?

2 Replies


Instead of VBA, consider the use of a separate Print worksheet for printing. Your users would use it to select the quarter from a dropdown list, adjust the print area/scaling if necessary, and print it.


See the attached workbook.  The _Info worksheet has notes and URLs for related documentation.



Thank you.  I'll give it a try.  Looks like it will be simple for the users.