Completed

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

About the Employer:
( 4 reviews ) Odessa, Ukraine

Project ID: #6619117

Awarded to:

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

$30 USD in 1 day
(79 Reviews)
5.8

9 freelancers are bidding on average $23 for this job

danielgpratidya

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

$30 USD in 1 day
(55 Reviews)
5.7
rengrish

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)
5.1
Khurramz

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)
4.3
dhiren707

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)
3.6
sreejithakaz

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)
1.2
janjiczika

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

$10 USD in 1 day
(0 Reviews)
0.0
egulen2000

Bir öneri henüz sağlanmadı

$21 USD in 1 day
(0 Reviews)
0.0