HOW DO I AUTOMATICALLY DELETE ROWS WITH ZERO BALANCES?

S

suec4

I have a spreadsheet with calculations that may result in a zero balance.
How do I automatically delete all rows with a zero balance?
 
R

Richard Buttrey

I have a spreadsheet with calculations that may result in a zero balance.
How do I automatically delete all rows with a zero balance?
Click to expand...

One way would be to filter the list to display the zero values. Then
delete those rows and unfilter the list.

If you want it to be automatic, then a simple macro to perform those
steps would do the trick.

HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
 
Top