Suljettu

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, need someone write vba macro excel, excel custom email macro, excel macro target custom name adress, need macro excel repeats copy paste, excel macro move rows need speed process, convert excel 2000 macro excel 2007 macro, vba macro excel unicode, query macro excel, macro excel cells

Tietoa työnantajasta:
( 0 arvostelua ) KARACHI, Pakistan

Projektin tunnus: #8646066

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

zExcel

A proposal has not yet been provided

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

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)
5.9
fabest

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)
5.5
watersev

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)
5.3
FIBIN

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)
5.3
paris2785

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)
5.4
JonNxt

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)
4.9
AlexandrK1

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)
4.5
renesontiongson

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)
4.1
fatimatuzzohura

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)
3.7
Baxter2008

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)
3.9
shagoon2u

Hi Recruiter, We have sandwidth to start immediately. Please refer to our website [url removed, login to view] for our credentialy. Thanks Shakun Rastogi

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

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)
3.1
lalmansari

-> 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)
3.3
jpablocar

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)
2.0
reshamdeshpande

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

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

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)
0.0
Pimomigue

A proposal has not yet been provided

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

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

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

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)
0.0