+ Reply to Thread
Results 1 to 1 of 1

Excel Macro Reconciliation

  1. #1
    Registered User
    Join Date
    Zurich, Switzerland
    MS-Off Ver
    Excel 2003

    Excel Macro Reconciliation

    Dear Experts,

    i have a vision but that is already it - i found a few posts regarding similar problems and im sure this is possible to do - just don't know how
    im looking for a macro to reconcile transactions netting to zero. daily i get a predefined output file containing necessary infromation like portfolio, account type, currency and amount - all other columns are irrelevant - i attached a sample . This file is usually between 800 and 1500 records and probably 30% could be matched - this is what im after. There are very few 1:1 amount matches, great majority is the sum of several amounts netting off - Usually there are 5-15 trx by account/type/currency combination, rarely there is one with 20-25 items.

    My goal is to identify all matches (zero or with little tolerance) within each account/type/currency combination (in column A) - If a match is found it should mark it as "match" (preferably in column N), if not it should move on to the next account until finished. - would be nice it would be finished within one hour.

    i really appreciate if someone could help me with a smart and simple solution
    many thanks in advance
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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