Results 1 to 6 of 6

Many to one matching from 2 columns (bank reconciliation)

Threaded View

  1. #1
    Registered User
    Join Date
    03-04-2013
    Location
    Portugal
    MS-Off Ver
    Excel 2007
    Posts
    7

    Many to one matching from 2 columns (bank reconciliation)

    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
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1