How to auto hide an empty row?

  • Thread starter Thread starter Applewine
  • Start date Start date
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)
 
Can you use Data>Filter>Autofilter and filter 'Non Blanks'

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
Thanks for your reply, but I need something more automatic, and
transparent to the user...(probably a VBA sub checking the Change
event?)
 
Back
Top