I’m having excel sheet with debit transaction and Credit transaction in specific dates, I want VBA code to sum the previous debit transaction when Credit transaction occur and reconcile the amount if the credit amount greater than total previous amount the result be zero if false the result be unsettled amount and it belong to which date and this action restart again when credit transaction happens again but not taking the previous settled ones.