Excel Macro: Auto Credit Allocation

I keep my customer ledger in an existing Excel workbook. Each time I receive the bank statement it arrives as an Excel file, laid out on a single sheet that lists every transaction. The customer’s name... (Budget: ₹600 - ₹1500 INR, Jobs: Data Entry, Data Management, Data Processing, Excel, Excel Macros, Excel VBA, Visual Basic, Visual Basic for Apps)