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? |
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