Suoritettu

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 [login to view URL] which is currently formatted as Last Name, First Name), and "Address"

3) Macro loads [login to view URL] (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:
( 18 arvostelua ) Lehigh Acres, 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ä
(10 Arvostelua)
2.4

36 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

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ä
(566 arvostelua)
8.2
zExcel

A proposal has not yet been provided

$100 USD 1 päivässä
(253 arvostelua)
7.6
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ä
(157 arvostelua)
6.9
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ä
(184 arvostelua)
7.1
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ä
(203 arvostelua)
7.0
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ä
(93 arvostelua)
6.8
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ä
(244 arvostelua)
6.6
TonmoyRoy111

A proposal has not yet been provided

$60 USD 3 päivässä
(249 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ä
(145 arvostelua)
6.6
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ä
(127 arvostelua)
6.5
zebracaro

I can do it for you quickly and exactly .

$70 USD 3 päivässä
(93 arvostelua)
6.4
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ä
(100 arvostelua)
6.0
gayuh

Hi! I offer my service to write the macro. I am a programmer of server, desktop, web & mobile applications. Proficient in Microsoft .NET + MS SQL Server, PHP + MySQL, and Android platform, I also do graphic desig Lisää

$50 USD 1 päivässä
(95 arvostelua)
6.0
axiomswb

I have expertise in Excel, VBA, SQL... I can provide you quality of solutions.. feel free to communicate.. Thank you

$50 USD 1 päivässä
(37 arvostelua)
5.7
sknadeem123

A proposal has not yet been provided

$205 USD 3 päivässä
(52 arvostelua)
5.8
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ä
(62 arvostelua)
5.7
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ä
(61 arvostelua)
5.6
BDtW

Hello, I am Shahed, the clients communication officer from BDtW. Thank you for your detailed explanation. Here is a little description of our related experiences: All of our completed works here in freelance Lisää

$66 USD 3 päivässä
(32 arvostelua)
5.2
surekash7096

I have the expertise in Excel and can write a macro exactly for your specifications, quickly and accurately.

$100 USD 2 päivässä
(67 arvostelua)
5.2