Loop until Sum equals Zero ($0.00) - then Insert Row
Below are only rows 147 - 154 (No of Rows will vary) (from Beginning at Row
5 - always)
A B C D
E F
2/28/06 101 Deposit Accts Rec 101001
2,430.00
2/28/06 101 Deposit Accts Rec
120001 -1,000,00
2/28/06 101 Deposit Accts Rec
120001 -1,000.00
2/28/06 101 Deposit Accts Rec
120001 - 430.00
2/28/06 101 Deposit Accts Rec 101001
53,496.26
2/28/06 101 Deposit Accts Rec
120001 -53,496.26
2/28/06 101 Deposit Accts Rec 101001
38,495.25
2/28/06 101 Deposit Accts Rec
120001 -38,495.25
I need to insert a BLANK ROW between all SELF-BALANCING Rows to have look
like:
A B C D
E F
2/28/06 101 Deposit Accts Rec 101001
2,430.00
2/28/06 101 Deposit Accts Rec
120001 -1,000,00
2/28/06 101 Deposit Accts Rec
120001 -1,000.00
2/28/06 101 Deposit Accts Rec
120001 - 430.00
2/28/06 101 Deposit Accts Rec 101001
53,496.26
2/28/06 101 Deposit Accts Rec
120001 -53,496.26
2/28/06 101 Deposit Accts Rec 101001
38,495.25
2/28/06 101 Deposit Accts Rec
120001 -38,495.25
But how?
TIA,,,
|