Find Jobs
Hire Freelancers

Need VBA code for excel

$25-50 USD / hour

Closed
Posted over 6 years ago

$25-50 USD / hour

I pull spreadsheets daily that contain lists of usernames. I need an easy way (VBA?) to replace each name with the corresponding ID. Currently, it is a total pain having to copy/paste the info using replace - the list is 70 people long and growing.
Project ID: 15694189

About the project

59 proposals
Remote project
Active 6 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
59 freelancers are bidding on average $31 USD/hour for this job
User Avatar
Hello Sir, Thank you for this opportunity. My name is Jay and I am an Expert Techno-Functional Analyst having vast experience in Excel Macros and Formulas. I am an Engineering Graduate with an MBA. If you see I am among niche bidders who have 0 failed projects and 100% 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. Pay me only when your job is 100% done. Also I will provide you with a sample work before you consider awarding me the project. Thanks, Jay
$32 USD in 40 days
5.0 (940 reviews)
9.4
9.4
User Avatar
Hi there. My name's Paris. I can develop a simple macro to replace the ID by using a vlookup function integrated with Excel. All you have to do is click a single button and the code will do the rest, thus scanning all rows and trying to find a match. Once it finds a match it will replace it with the needed value. I can deliver within a couple of days. Paris
$25 USD in 40 days
5.0 (679 reviews)
8.7
8.7
User Avatar
Greetings sir, i can help you and your 100% satisfaction is assured if you allow me to serve. I can do this task as per your requirement I have more than 5 years of experience with excellent knowledge in Data Entry, Data Processing, Excel, Visual Basic. please give me a chance to work on your project
$25 USD in 40 days
4.9 (611 reviews)
8.6
8.6
User Avatar
Hi, Swheatley! I can create a simple VBA tool which will replace names in excel file with matching id's by simple button click. Or we can create more complicated tool which will automatically pool the spreadsheet and prepare resulting file on a scheduled basis. Please contact me to discuss project details.
$40 USD in 20 days
4.9 (72 reviews)
7.8
7.8
User Avatar
Dear Client, I understand the scope of work completely. I can autommate this task and make everything easy for you. So please contcat me. Roy
$25 USD in 40 days
5.0 (516 reviews)
7.8
7.8
User Avatar
"I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. I am a Business (MBA) Graduate with major in Finance and MARKETING along with 5 years of experience in different analytical roles. Currently I am working for a Multinational Telecommunication Company as an B2B Analyst Manager.I believe I can do a fantastic work for you if you provide me the opportunity. "
$30 USD in 10 days
4.9 (281 reviews)
7.1
7.1
User Avatar
Greetings! This is a very easy and direct requirement to implement. Would you be able to share the workbook? I have 18 years experience in using Excel as part of my daily work life. In the process I have implemented lot of automation similar to what you are expecting as well as dashboards for Management Reporting. In fact, over the last 17 MONTHS , I have spent at least 250 HOURS on automation in Excel every month. Have a Great Day! Srinivasan Krishnamoorthi
$25 USD in 2 days
5.0 (260 reviews)
7.2
7.2
User Avatar
Hello, I have read and understood what has to be done in this task. I have sound experience in performing such kind of work....Hoping to serve you in the best possible manner and completing it to your level of satisfaction. Looking forward to work for you. Hope to hear from you. Have a nice day. Regards, Nidhi.....
$25 USD in 40 days
4.9 (156 reviews)
7.0
7.0
User Avatar
Hi there, I can do this easily by creating a custom user function that you can use. I am an expert in Excel VBA with over 5+ years of experience. Ping me to discuss more. Thanks Aman
$27 USD in 10 days
4.9 (179 reviews)
6.6
6.6
User Avatar
Hi, I think better way Ms Access/vba GUI or directly via Excel, But first will be way more convenient for you(here also possible Excel export etc). Thanks for your time and Regards, Zura
$25 USD in 40 days
4.7 (49 reviews)
6.2
6.2
User Avatar
Hi, Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I will give you single click solution to replace name with corresponding ID. I have excellent knowledge and experience of string manipulation through excel vba programming. So, I can develop a macro to accomplish this job automatically. Ready to start please reply soon. Thanks, Virendra
$33 USD in 40 days
4.9 (153 reviews)
6.2
6.2
User Avatar
Dear Employer Thanks for giving us chance to submit proposal on your project Coming to your project details we will develop your application using vb.net .Ping me via chat box and provide me spread sheet and all details so that we can go through with our developer we have exp programmer in our company with 3-7 years exp and we will deliver you quality work I will be waiting for your reply asap Regards Sam
$28 USD in 40 days
4.9 (6 reviews)
6.2
6.2
User Avatar
Hello, I can easily create a macro the will replace the name with the ID. You will be able to easily edit the list and other options if requested. Please open a chat with me if you are interested. Kind regards, Sorin
$25 USD in 10 days
5.0 (80 reviews)
5.8
5.8
User Avatar
I have 7 years of experience in Excel and VBA. I ll automate your growing list and complete the action. See my profile for client reviews. I ll deliver in only 5 hours. @$25
$27 USD in 5 days
4.9 (34 reviews)
5.6
5.6
User Avatar
Hi, I am Nallakumar. I have more than 11 years of experience in VBA and office automation. We can create a button and upon clicking the button, we will do all the replace actions automatically. Thanks, Nalla
$25 USD in 8 days
5.0 (16 reviews)
5.6
5.6
User Avatar
Pleasure to help you. Excel automation is my masterpiece in my accounting field. Feel free to message me to start the job. Thank you so much.
$25 USD in 40 days
4.9 (76 reviews)
5.7
5.7
User Avatar
Hi, I can do this within 2-4 hours easily. Have worked extensively on macros. looking fwd for your response to my bid.
$25 USD in 10 days
5.0 (9 reviews)
5.3
5.3
User Avatar
Hi, I went through the description. This job is quite similar to my previous project. This can be done in 1-2 days. I am looking forward to hearing from you price can be negotiated. Thanks Regards Thushara
$27 USD in 10 days
5.0 (42 reviews)
5.3
5.3
User Avatar
Of course this is an easy job on VBA. I have 10+ experience in doing VBA programs and this kind of job is very easy for me.
$30 USD in 50 days
4.7 (20 reviews)
5.0
5.0
User Avatar
Dear Customer . i understand your requirement and will Provide sample work within 1 hours. trust me and Hire me .
$25 USD in 40 days
4.9 (12 reviews)
3.6
3.6

About the client

Flag of UNITED STATES
United States
0.0
0
Member since Nov 21, 2017

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.