View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim May Jim May is offline
external usenet poster
 
Posts: 430
Default 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,,,