Macro to remove rows, i.e. reformat a report

Hi All,

I'm trying to write a macro to reformat and cut down the length of a current monthly report i receive. I would like to remove report lines which contain zero values.

I've attached a reworked example of the report format.

The macro would remove lines 8, 10, 14 etc. as there are no values in those lines but it would not remove any other lines like row 1-7, 13, 20-24 etc. (report details & headings).

Oh and the macro should be applied across all tabs within the workbook.

any help on getting me on the right track would be appreciated.

Regards
Neill

OMW Dom thanks so much that code is insane!