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 sho...
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.
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.