I have created multiple reports in one sheet. Each report is 10 rows with one empty row between reports.

The first report is in cells A2:G11, the second report is in cells A13:G22, the third report is in cells A24:G33 and so on for another 57 reports.

If the total in the first report, cell F11, is £0.00 then I do not want to print the report. If the total is equal to or more than £0.01 then I do want to print it. The total value for the second report is in cell F22, for the third it is in cell F33 and so on for another 57 reports.

I currently manually hide the rows that I do not want to print and print the remainder. Is there any way that I can print the reports that I want automatically, perhaps by macros?

TIA