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