Oct 03 2019 05:59 PM
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.
Oct 04 2019 04:46 AM
SolutionThat'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.
Oct 04 2019 04:46 AM
SolutionThat'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.