Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 296
Default 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
__________________________
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
delete blank rows Pam C Excel Discussion (Misc queries) 1 January 17th 06 07:13 PM
Excel - How do I delete filtered out rows? rook Excel Discussion (Misc queries) 2 November 30th 05 10:45 PM
delete rows Jack Sons Excel Discussion (Misc queries) 5 November 22nd 05 04:30 PM
Delete Rows where cells does not meet criteria Danny Excel Worksheet Functions 1 September 12th 05 05:08 PM
delete repeating rows aledger Excel Worksheet Functions 2 March 4th 05 08:43 PM


All times are GMT +1. The time now is 08:06 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"