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

@rab52764 

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.

@SnowMan55 

 

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