Find Jobs
Hire Freelancers

Write an Excel Macro

$10-30 USD

Completed
Posted over 9 years ago

$10-30 USD

Paid on delivery
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
Project ID: 6619117

About the project

9 proposals
Remote project
Active 9 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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 niche bidders who have zero failed projects and very high completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. Thanks, Jay
$30 USD in 1 day
5.0 (79 reviews)
5.8
5.8
9 freelancers are bidding on average $23 USD for this job
User Avatar
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 I only have windows here. 2. In your point 1 (if name is found) you mentioned "up to five" first record, could you please explain further with example? 3. In your point 2 (If not found) you only have unique ID until row 829, if the new record exceed this line, can I create new unique ID by adding the previous by 1? Let me know if you're interested to working with me. Cheers, Daniel
$25 USD in 3 days
5.0 (119 reviews)
6.1
6.1
User Avatar
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 contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet containing cells populated by the usual Open file and/or select folder dialogs to identify the current input and output files and hosting command buttons and other controls if necessary. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. Regards
$30 USD in 1 day
4.9 (55 reviews)
5.7
5.7
User Avatar
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
4.9 (37 reviews)
4.3
4.3
User Avatar
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
5.0 (18 reviews)
3.6
3.6
User Avatar
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 this using VBA.
$25 USD in 1 day
5.0 (1 review)
1.2
1.2
User Avatar
I am electrical engineer with strong knowledge of excel and visual basic. Also, very reliable.------
$10 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Bir öneri henüz sağlanmadı
$21 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UKRAINE
Odessa, Ukraine
5.0
4
Payment method verified
Member since Jun 19, 2014

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.