Write an Excel Macro

Hello, Freelancer!

I need Excel Macro to text manipulation

I have a couple of hundreds strings with names and surnames, separated by commas. String can contain various number of names

Also I have a separate spreadsheet with names , surnames and unique ID's

What I want from macro:

1. Lookup for each name and surname in second spreadsheet and, if found, return concatenated ID, name, surname – in the same row , different column with only up to five first records

2. If Name not found in second spreadsheet – add it to this spreadsheet, and also return value to previous line with concatenated ID. Second spreadsheet already has a more than 700 names, so we cannot start making a new spreadsheet

In attachment you will find all files about project description and data

Skills: Data Entry, Data Processing, Excel

See more: write names, what write in freelancer, string manipulation c, i need excel freelancer, i need an excel freelancer, freelancer lookup, freelancer for excel macro, data entry macro, freelancer id name, sergeyborodkin, need a freelancer for excel macro, text manipulation, spreadsheet manipulation, number manipulation, excel macro add, write macro, excel macro row, excel add strings, excel unique, excel 2014 macro, write data excel spreadsheet, data manipulation excel macro, macro spreadsheet, excel text column, add excel macro

About the Employer:
( 4 reviews ) Odessa, Ukraine

Project ID: #6619117

Awarded to:


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 n More

$30 USD in 1 day
(79 Reviews)

9 freelancers are bidding on average $23 for this job


Hi, I'll gladly to help you out with your project, but I need you to clarify some questions: 1. Do you use Mac or Windows? this is important, because some codes created in windows platform won't work on Mac. While More

$25 USD in 3 days
(119 Reviews)

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 contain More

$30 USD in 1 day
(55 Reviews)

I have done similar kind of job. Please check this dropbox link. [login to view URL] I can complete this job within few mins.

$25 USD in 1 day
(78 Reviews)

Hello! I can help you with this macro creation. Will be back in 3-4 hours, in case you do not hire, I'll start immediately.

$14 USD in 1 day
(37 Reviews)

I can do this via programming instead of making Macro. It will do the task as mentioned and will give you the data as needed. Thanks.

$30 USD in 1 day
(18 Reviews)

I have over 8 years of experience in Excel and Access VBA. I have developed several Application, Tools, Dashboard and Online Tools using VBA. I have done similar projects in the past and would be able to complete th More

$25 USD in 1 day
(1 Review)

I am electrical engineer with strong knowledge of excel and visual basic. Also, very reliable.------

$10 USD in 1 day
(0 Reviews)

Bir öneri henüz sağlanmadı

$21 USD in 1 day
(0 Reviews)