Käynnissä

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:
( 14 reviews ) Fort Myers, United States

Projektin tunnus: #8645078

Myönnetty käyttäjälle:

andreapellicci

Hi, I'm new on this site, but I'm very skilled on excel and visual basic and I've already obtained some reviews that you may check on my profile. I'd like to work on your project, so I hope to be contacted. If you Lisää

40 $ USD 3 päivässä
(8 arvostelua)
1.8

38 freelanceria on tarjonnut keskimäärin 101 $ tähän työhön

zExcel

A proposal has not yet been provided

100 $ USD 1 päivässä
(207 arvostelua)
7.2
jaylancer43

Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among Lisää

100 $ USD 3 päivässä
(164 arvostelua)
6.8
aarifakhtar

Hi: I have a few questions: Can there be issues with the spelling? For instance: In agent sheet the name is Thomas Buckel while the name in Owner sheet is Tom Buckel. If this is the case, then the macro will require fu Lisää

111 $ USD 3 päivässä
(79 arvostelua)
6.1
DeepSyaal

Lets start. Having a team of Professionals. We provide high quality work with accuracy. Would you like to discuss more about your current requirements?

90 $ USD 1 päivässä
(193 arvostelua)
6.3
fhasanbd

Hi, I am passionate,I am an extremely motivated individual who pays attention to detail. I always make sure my work is complete and accurate. I am also an ambitious person and I desire to be among the best in my fi Lisää

250 $ USD 4 päivässä
(127 arvostelua)
6.4
flashsaiful

Hello Dear, I can do this for you. Please send a massage in the PMB for details.......Best Regards flashsaiful

155 $ USD 3 päivässä
(97 arvostelua)
6.1
cugamelover

I'm a computer science professional with a PhD degree and extensive experience in Excel and VBA. Please see reviews on my profile. It would be my pleasure to do your project. Please have a look at some Excel project Lisää

80 $ USD 2 päivässä
(49 arvostelua)
6.0
wsh2

Greetings from Easton PA.. {smile} Highly experienced (20+ years) MsExcel Business programming and database expert with Guru / Mentor level technical credentials at www.experts-exchange.com and www.vbcity.com. St Lisää

155 $ USD 3 päivässä
(27 arvostelua)
5.7
gokulanand

Hello I can get you this task done in the next 24 hours using Excel VBA programming.. Please let me know if you are interested.. Thanks

80 $ USD 1 päivässä
(66 arvostelua)
5.5
pkcyber

i can develop an automated application, that can take the excel files as input and give you output file of matching records in new file. it will be simple and fact application. Keenly looking forward your respons Lisää

50 $ USD 1 päivässä
(31 arvostelua)
5.6
nagybatonyi

I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. I plan to complete the project via writing an Excel macro conta Lisää

66 $ USD 3 päivässä
(56 arvostelua)
5.7
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ää

89 $ USD 4 päivässä
(54 arvostelua)
5.4
DanielVizcaya91

Hi there. I am a professional developer with plenty of experience working with MS-Excel and VBA macros. I can guarantee you an excellent jon and deliver as soon as possible. I have checked the files you attatched and i Lisää

199 $ USD 3 päivässä
(26 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 can send first draft for your approval within 24 hours .

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

I can do it for you quickly and exactly .

70 $ USD 3 päivässä
(39 arvostelua)
4.5
sknadeem123

A proposal has not yet been provided

205 $ USD 3 päivässä
(21 arvostelua)
4.5
macroPOL

Hello, I can do the project. If you have any questions I will be happy to answer. Best regards Jan Krzyzak

100 $ USD 7 päivässä
(12 arvostelua)
4.1
rajafaizan

I am very interested in your project. I have 5+ years exp. in MS Office, Designing, Quick-books, Office Management, PDF, Google spreadsheet, Vba and typing. I will give you my best possible work. I would like to thank Lisää

174 $ USD 5 päivässä
(23 arvostelua)
4.2
farr4u

HI, expert here ready to start, please provide more details of the work, I assure you high quality work done, thanks and regards.

98 $ USD 3 päivässä
(29 arvostelua)
4.3