G Guest Aug 25, 2006 #1 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?
R Richard Buttrey Aug 25, 2006 #2 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 __________________________
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 __________________________
