G

#### Guest

Customer is delinquent for 10 payments of total $25,850 (Col b2)/each

monthly payment of $2585(Col a2). I extract the customers arrears from data

warehouse which populates From Current billed to 90-120days (column C2 to G2)

per below. 90-120days column which is last column has $15,510 balance. I

would like to add four more column (121+,151+,181+,211+days) extending the

delinquent amount by each monthly payment of $2,585. So the each monthly

delinquent amount is spread to 9 columns (Col c2 thru Col k2). Col K (211+)

would have $5170 balance.

Per data warehouse Extract

Col A1 -Monthly Rent Col A2- $2,585

B1-Total Arrears B2- $25,850

C1-Current Billed C2- $2,585

D1-1-30 days D2-$2,585

E1-31+ E2-$2,585

F1-61+ F2-$2,585

G1-91+ G2-$15,510

I am looking for a solution (formula for Col H2 thru k2 or macro) where Col

G2 should have $2585 delinquent amount instead of $15,510 and it should

further populate the delinquent to column H2, I2, J2 in the amount of $2585

each and K should have $5170 balance.

Thanks for the help.

Dinesh