G
Guest
Hello Experts,
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
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