Need custom Excel macro

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.

Taidot: tietojenkäsittely, Excel

Näytä lisää: review matches, need macro excel, excel custom email macro, vba macro excel unicode, query macro excel, macro excel cells

About the Employer:
( 0 reviews ) KARACHI, Pakistan

Projektin tunnus: #8646066

39 freelanceria on tarjonnut keskimäärin 68 $ tähän työhön


A proposal has not yet been provided

100 $ USD 1 päivässä
(208 arvostelua)

Hello Sir Im excel VBA macro and formula Expert :) i can do anything in excel via VBA macro :) please give me a chance for doing your job and im able to start doing your job right now Thank You SIncerely Prame Lisää

30 $ USD 1 päivässä
(153 arvostelua)

Dear, we are Team of French + US. 11 years experience on Access/Excel/VBA automations. I checked your project description, and I confirm I can develop your program. I will focus on user friendly interface. As you c Lisää

94 $ USD 3 päivässä
(17 arvostelua)

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

30 $ USD 1 päivässä
(88 arvostelua)

Hi I am interested to work for your project . I am an expert in excel and VBA Programming in Excel. I have experience working on lot of Excel based projects. I will make sure that I deliver you the best with 100% ac Lisää

50 $ USD 3 päivässä
(49 arvostelua)

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your pr Lisää

79 $ USD 3 päivässä
(56 arvostelua)

Hi there, I've been working with Excel since before '98 and I've been using all possible versions of it. I have years of experience working with macros and writing / debugging VBA code. You may check my portfolio Lisää

65 $ USD 1 päivässä
(34 arvostelua)

please inform about next steps i can send first draft for your test within 1-2 days and complete within 3-4 days

250 $ USD 3 päivässä
(13 arvostelua)

Hi! excel automation is my masterpiece in my accounting field. Pleasure if you choose me to work with you. Thank you.

60 $ USD 3 päivässä
(25 arvostelua)

I have versatile experiences about to do the online research, excel data analysis work. Please find below my overview: Extensive Excel and pivot table development experience Excellent familiarity with all Microsoft Lisää

83 $ USD 3 päivässä
(16 arvostelua)

Hello. I am an Excel VBA developer. I can write this small macro for you... Excel open file dialogs to select both files, split out names, do comparison against last name and first/initial and then write the possibilit Lisää

45 $ USD 1 päivässä
(19 arvostelua)

Hi Recruiter, We have sandwidth to start immediately. Please refer to our website for our credentialy. Thanks Shakun Rastogi

83 $ USD 1 päivässä
(4 arvostelua)

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...

50 $ USD 1 päivässä
(17 arvostelua)

-> Excellent Programmer -> 4+ years of experience in VBA programming, Web Scraping, Dashboard designing and Excel/Word Macro Development -> Will provide high quality product. -> I have a Master degree in Computer A Lisää

55 $ USD 3 päivässä
(7 arvostelua)

Hi, my name is Juan Pablo Carreras. As an engineer, I am proficient in the use of excel and the automation of tasks within it, using macros and VBA. I have been doing this for over ten years, so, I am capable of giv Lisää

70 $ USD 3 päivässä
(4 arvostelua)

I am available on skype/whats up/facebook/team viewer I have 3 years of experience in IT industry. I have worked on, sql server and excel macros, Wordpress. Work done in Excel Macros - -Many Complex Macr Lisää

50 $ USD 3 päivässä
(2 arvostelua)

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 !

61 $ USD 2 päivässä
(0 arvostelua)

A proposal has not yet been provided

100 $ USD 2 päivässä
(0 arvostelua)

Hi, I am a very good VBA programmer so i can help you with it :) Lisää

45 $ USD 0 päivässä
(0 arvostelua)

I am the VB6.0/Dot Net Professional Developer/ SQL Server developer. My professional experience includes extensive hands on expertise on Microsoft technologies.I understand how to build project that directly meet user Lisää

100 $ USD 2 päivässä
(0 arvostelua)