Forum Discussion
Solved
Macro to reconcile Large Set of Data (Bank Statement to Transactions)
Hi
I have very large sets of data (10k transactions per day). I wish to have a macro to match bank statement to transactions waiting for money. I am aiming to have it spit out a report which shows transactions on the bank statement which weren't matched, and one which shows transactions still waiting for money.
Attached is a template example.
Can someone please assist.
That's job for Power Query if you consider such option - query all transactions, create reference queries, filter them as needed and load results back to Excel spreadsheet.
1 Reply
That's job for Power Query if you consider such option - query all transactions, create reference queries, filter them as needed and load results back to Excel spreadsheet.