View Single Post
  #1  
Old September 9th, 2010, 09:22 PM
chrisjack001 chrisjack001 is offline
Member
 
First recorded activity by OfficeFrustration: Sep 2010
Posts: 1
Default Conditional Delete Statement

I want to create a code that can run through the entire spreadsheet and delete the rows of all accounts that have $0 or less Outstanding balance. Example in the above sample account 31203 started with an outstanding balance of $21,803 but had one transaction that resulted in an ending balance of $0. As a result of this all rows of account 31203 should be deleted and data moved up. All accounts that have Outstanding balances like account # 76292 & 56512 in the above will not be deleted because they have outstanding balances of $1000 and $24.900 respectively. The only Accounts that will remain on the spreadsheet will be account numbers with Outstanding balances. Can you please help me create a macro or a VBA code to accomplish this task I am new at this. Thanks for your help.