On the spreadsheet, I need to march the debit and credit throughout the month. I am now manually to compare each line data. The debit and credit may happen in different days. Also, I want to create a macro to split the debit and credit into two columns, also have a running balance for each day. Please see attached file.
Thank you for your help.