Reduces breakdown from total amount and then update the balance until balance is zero

Hi All,

I have two sheets, sheet1 contains month wise installment, sheet2 has related paid amount, I want to relate the paid amounts to instalments.

Please Login or Register  to view this content.

i tried the below code, it nearly worked, but doesn't loop by updating the new balance in sheet2 and when the balance becomes zero, the profit should be zero for relevant rows.

Please Login or Register  to view this content.

can someone help me please, i have also attached the workbook.