HOW DO I AUTOMATICALLY DELETE ROWS WITH ZERO BALANCES?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet with calculations that may result in a zero balance.
How do I automatically delete all rows with a zero balance?
 
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
__________________________
 

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

Similar Threads

First row where a cell is zero 1
DELETE ALL ROWS & COLUMNS WITH ZERO BALACES 1
CONCATENATE zeros 5
if one cell equals zero then the next cell should say N/A 1
how do I automatically hide or suppress zero balance rows 1
Compare 2 lists of random numbers - Excel 2007 4
Need formula to change cells from negative numbers to a zero. 2
Possible problem with PMT and FV functions 2

Back
Top