ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   HOW DO I AUTOMATICALLY DELETE ROWS WITH ZERO BALANCES? (https://www.excelbanter.com/excel-worksheet-functions/107107-how-do-i-automatically-delete-rows-zero-balances.html)

suec4

HOW DO I AUTOMATICALLY DELETE ROWS WITH ZERO BALANCES?
 
I have a spreadsheet with calculations that may result in a zero balance.
How do I automatically delete all rows with a zero balance?

Richard Buttrey

HOW DO I AUTOMATICALLY DELETE ROWS WITH ZERO BALANCES?
 
On Fri, 25 Aug 2006 06:35:01 -0700, suec4
wrote:

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
__________________________


All times are GMT +1. The time now is 03:05 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com