How to auto hide an empty row?

A

Applewine

Is it possible to have Excel hide a row automatically if there is no
entry there?

My worksheet Subtotals data on 7 rows, then creates a Total on the 8th
row.
If there is no data on any row, can I hide them so the Total line
appears right below the last entry?

For example:

Subtotal 1 (SUMIF function used)
Subtotal 2 (SUMIF function used)
Subtotal 3 (SUMIF function used)
Subtotal 4 (SUMIF function used)
Empty Subtotal 5 (SUMIF function used)
Empty Subtotal 6 (SUMIF function used)
Empty Subtotal 7 (SUMIF function used)
TOTAL (SUM of all above)
 
A

Applewine

Thanks for your reply, but I need something more automatic, and
transparent to the user...(probably a VBA sub checking the Change
event?)
 
Top