Hi guys,
First of all, I use Excel 2007.
Now, this task I am stuck with might be easy for experienced VBA-programmers, but I as a rookie have been struggling to complete it. I really need this tool for my masters thesis, since I can’t proceed to next step before it Is done. Therefore I ask for your help.
I have attached a simplified excel-workbook with the relevant content (Please see the link in the bottom).
In this excel workbook there are 3 sheets. “PE_firms”, “Industry_firms” and “Matched_list”. “PE_firms” contains a list of 4 private equity firms, and the task I need VBA to perform is to match these with 4 companies from “Industry_firms” (based on the following matching criteria), and copy the full rows of the 8 matched companies and paste them into “Matched_list”:
Matching criteria:
• First, match with the 2-digit industry code (or as close as possible)
• Second, match with year of the deal (or as close as possible)
• Third, find the closest match on pre_performance (measured by ROA) within a reasonable range of company size (measured by total assets)
NB. If any of the requirements, steps or formats are creating problems, please let me know, and I will reply within a few minutes. Maybe we can loosen or alter them a bit.
Link to the uploaded workbook: http://www.speedyshare.com/Te3kR/Matching-Workbook.xlsx
As mentioned, this file I a simplified one. Really I need 500 PE firms matched with industry firms from a list of 4000, so manual matching is not really an option.
In advance, thanks a lot for any help!