Macro for hiding zero data rows while printing

[Sandy]

I want to print an Excel report where rows are accounts and columns are
periods, and the data is in dollars. The report should not print out all
those rows that have zero data in them. Can a macro or a combination of some
Excel function & macro do that? How?

 

[Steve]

I want to print an Excel report where rows are accounts and columns are
periods, and the data is in dollars. The report should not print out all
those rows that have zero data in them. Can a macro or a combination of some
Excel function & macro do that? How?

Sandy,

This depends on your needs and freedom to amend the sheet.

With a problem as you have described, I would generally insert a
column with a flag, perhaps as simple as a sum of the periods???? Then
I would insert autofilters at the column headers, and filter the flag
column on non zero amounts.

There are a few other solutions that are mechanical, but the method
above is quick and relativley simple to initiate and remove.

Steve