VBA: 'pair matching' 2 closest match 2 companies from 2 datasets based on size, industry+

Hello coders and VBA gurus,

now crossposted here: http://www.excelforum.com/excel-prog...-industry.html (stated as rule ask to admit cross-posting) -reason due to no response and now on 4/5th page.

Your help is much appreciated and urgently requested about the below.

I have the following piece of code which did the job I want to do on another dataset. Unfortunately I do not have the original dataset.

What I think this program is supposed to do roughly is:

= Find the closest matching pair of companies from two datasets/worksheets
= According to firstly SIZE (Asset)
= Then INDUSTRY (as represented by the 'SIC' code)
= Then other variables (as desired) - in my sample case the variables I want to match on are: a001000000(size); incd (industry code); roa mbr; dar in that order
= So that you are left with a dataset with a sample of the firms from each of the two original datasets, in pairs, so that they are closely matched in terms of all but the separating variable that separates the two datasets (i.e. in the case below "Chinese" or "US")

How can I implement the code provided to do as above but using my sample, for example?

I include a sample of my own data. My problem is what do I need to change in the code (or my own dataset) in order to be able to run this program using my own dataset.

Here is the code:

Please Login or Register  to view this content.