How to Apply Payments to Aged Receivables Automatically using Excel VBA

[hhap]

....
OK, your last post makes it a lot clearer to me. I think now I either understand fully or I am close

I will do a simpler coding for you that will work on a single row. If you need help in adapting that to a final coding to suit you better, then let me know.
The coding is similar to my first attempt for you

Dear Alan, I have tested the updated vba/macro on one row and it worked . I am most grateful for your assistance . I will adapt it to cover all the rows . Thank you.