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
Bookmarks