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
|