I've got some Excel files and need a macro that will show possible matching values (names). Some files are lists of home owners (each file has between 100 and 1000 records - all with the same format) that will need to be matched against a file that is a list of agents (about 40,000 records). The process could be similar to:
1) Macro allows me to select the Agent file and the Owner file that will be matched.
2) Macro formats the Agent list into 3 columns: "Last Name", "First Name" (separates Column C of [url removed, login to view] which is currently formatted as Last Name, First Name), and "Address"
3) Macro loads [url removed, login to view] (which has Column A as "First Name", Column B as "Last Name", and Column C as "Address"
4) Macro switches Column A with Column B on Owners worksheet to make it same format as Agent worksheet
5) If Last Name and First Name AND/OR First Initial of a record on Agent Worksheet are found on Owner Worksheet, Macro populates a "Possible Matches" worksheet with BOTH instances (please see attached).
I'm looking for a separate worksheet or program to be populated with the possible matches rather than simply highlighting possible matches on the existing sheets. Source files are attached for review.
39 freelanceria on tarjonnut keskimäärin 68 $ tähän työhön
Hi there, I have a vast experience in Excel and VBA and would be happy to help you on the project. Best regards, Eugene PS. There are no file samples attached
Hi! I'm ready to do the job quickly and neatly. You will recieve what you want as soon as possible! I'm ready to start right now! But I do not see attachments...
I am an I.T professional with knowledge of excel macros. I am looking to start work in this freelancing world as side business. I can do this project error free, on time and within budget !