View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Markitos[_2_] Markitos[_2_] is offline
external usenet poster
 
Posts: 2
Default Deleting rows if the total is 0

Hello Everyone

I would like to be able to delete a row if the total is 0.

the transactions sheet would look like this(their is 12 transactions sheets)
Asset/ Payable acc. 101
Opening B. 0
New B. 30
Accounts 523 10
101 10
524
101
203
523
523
102 -1000
102 -2500
Month Rec.
Acc. Amount
101 30
102 -3500
103 0
104 0
105 0
203 0
523 10
524 0

THEN THE REPORTS SHEET would look like this.
Year Rec.
Acc. Amount
101 30
102 -3500
103 0
104 0
105 0
203 0
523 10
524 0

SO TO RECAP, I would like to delete the rows of accounts that our at 0.00 on
the reports sheet. and as well the transactions sheets.

THANKS SO MUCH FOR YOUR HELP.
-Markitos