Hi,
i want to create a file that helps me, in a monthly basis, to do the bank reconciliation.
I have manage to use some formulas to match 1 to 1 the values between accounting and the bank statement, as well the duplicated values.
However, i need to match many data to one matching, because we can pay to say 50 different suppliers at once, but in bank side it will only show one line.
What i need is to run a macro that only use the data where is no "x" or "duplicated values" and try to reconcile the movements and then place an ‘x’ next to all entries on the ledger and bank side, in order to show that these transactions have been reconciled.
I attached a sample of the file. This file have all data manual reconciled, but i need to add a code on button1 to do the last step.
Thanks in advance![]()
Bookmarks