I have a data set and I would like to apply payments to balances,
Basically applying the opening balance (Negative) to the bill starting with oldest to newest.
Attached is a sample
Sheet 1 is the transactions
Sheet 2 is opening payments
Sheet 3 is expected results
any help is greatly appreciated