Results 1 to 2 of 2

One to many and many to one match - macro or formula required

This is a discussion on One to many and many to one match - macro or formula required within the Excel Questions forums, part of the Question Forums category; All, We receive 2 files which need to reconciled. Both the files have common headers with details of trades that ...

  1. #1
    New Member
    Join Date
    Sep 2007
    Posts
    7

    Default One to many and many to one match - macro or formula required

    All,

    We receive 2 files which need to reconciled. Both the files have common headers with details of trades that need reconciliation.

    Trade date, Price , Type, Expiry Date, Qty, and Commission needs to be reconciled between 2 source files. Some time the qty of a particular trade is split into many lines in the first file against only 1 line in the second file or vice versa.

    I am looking for a macro or a formula which can help with this.

    Details in File 1
    Trade Date Quantity Trade Number
    01-Jan-2000 25 100200300
    01-Jan-2000 25 100200300
    01-Jan-2000 25 100200300
    01-Jan-2000 25 100200300

    Details in File 2

    Trade Date Quantity Trade Number
    01-Jan-2000 100 100200300


    50% of the reconciliation is straight forward and the macro is working fine for this. However we want to increase the effieciency of the macro to 80% and trade files will contain any where between 600 to 800 records.

    Appreciate help in this regard.

    Thanks,
    Pradeep

  2. #2
    Board Regular texasalynn's Avatar
    Join Date
    May 2002
    Location
    Houston, TX
    Posts
    8,308

    Default Re: One to many and many to one match - macro or formula required

    so what would your results look like that you want the formula or macro to produce?

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com