Build Macros for excel

Objective = build macro which can compare data from the Sharepoint file to the CMD file and populate in the Sharepoint file the possible customer ID number from the CMD file.

Things to consider ==

1. Customer name and city should be leveraged to compare the records.

2. Customer names will not be 100% match so need to factor in some variances. As such, consider the following:

a. If name is 100% match by the name disregarding symbols (eg. comma, periods, spaces, dashes, &) – consider it a match

b. If name is not 100% match but if you remove common words like (Co, Inc, Company, LLC, The, Corp) it is a match – consider it a match

3. In case more than one customer ID is possible, please include the multiple customer IDs identified.

4. Flexibility of Macro - We need to be able to have Macro which can be flexible in case we need to add more to be considered in 2.b.

3 files

1. End result file – sample of what is expected to be delivered

2. Sharepoint file – sample of file from Sharepoint source (does not contain the customer ID number)

3. CMD file – sample of file from CMD which does contain the customer ID number)

Skills: Excel, Visual Basic, Visual Basic for Apps

See more: convert lotus macros excel, macros excel info web, macros excel paypal, macro excel tutorial, excel macro examples, how to create a macro in excel 2010, excel macros for dummies, macros in excel for beginners, how to create a macro in excel 2013, use of macros in excel, how to create a macro in excel 2016, excel sql multiple query, macros excel data database, building macros excel, converting lotus 123 macros excel macros, activity log user macros excel sheets, activity log macros excel, improve macros excel, build program excel, converting 123 macros excel

About the Employer:
( 0 reviews ) Noida, Canada

Project ID: #17783669

Awarded to:


I have excellent command on MS Excel. I have completed complex projects in Excel before . For instance - Built a delivery schedule for pick-up and drop of raw-material under given constraints optimizing the utilizat More

₹3500 INR in 2 days
(75 Reviews)

I have been working on excel VBA & macro for more than 4.5 yrs. I have a good working knowledge of excel VBA & macro. I can work on tight timelines with high accuracy. I had made from scratch and also edited excel VBA More

₹850 INR in 3 days
(2 Reviews)

5 freelancers are bidding on average ₹1720 for this job


HI, I have 9 years of experience in excel. I am an expert in macro, vba, formulas etc. I have read and understood the project. Ping me for more discussion. Thanks

₹1500 INR in 0 days
(2 Reviews)

Hello Sir, I am expert 100% confident that I can execute the project with good quality. Thanks Loknath

₹1300 INR in 1 day
(0 Reviews)
₹1450 INR in 2 days
(0 Reviews)