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?

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
__________________________
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top