Forum Discussion
Report One Quarter at a Time
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?
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.
