Closed

Need VBA code for excel

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.

Skills: Data Entry, Data Processing, Excel, Visual Basic

See more: vba codes list, run vba code in excel, how to view code in excel, useful vba codes for excel, excel vba programming pdf, vba code library, vba code examples, vba excel download, backtesting vba code excel, protect vba code excel dll, extract vba code excel, vba code excel create clock, vba code excel 2007, simplex method vba code excel, view vba code excel

About the Employer:
( 0 reviews ) United States

Project ID: #15694189

69 freelancers are bidding on average $31/hour for this job

jaylancer43

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

$32 USD / hour
(536 Reviews)
8.1
$41 USD / hour
(259 Reviews)
7.7
schoudhary1553

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

$25 USD / hour
(229 Reviews)
7.3
$39 USD / hour
(275 Reviews)
7.1
Vlzinch

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

$40 USD / hour
(55 Reviews)
6.9
ksriniravi

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

$25 USD / hour
(129 Reviews)
6.4
TonmoyRoy111

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 / hour
(233 Reviews)
6.3
avinav606lx

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 / hour
(150 Reviews)
6.4
paris2785

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 More

$25 USD / hour
(124 Reviews)
6.5
Tanmoy236

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

$30 USD / hour
(106 Reviews)
6.2
NallakumarKC

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 / hour
(14 Reviews)
5.7
vsprybhanu

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

$33 USD / hour
(70 Reviews)
5.3
renesontiongson

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 / hour
(65 Reviews)
5.3
sumeet00

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 / hour
(9 Reviews)
5.3
zu02

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 / hour
(27 Reviews)
5.6
osmemon

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 / hour
(33 Reviews)
5.5
Nidhijain123

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

$25 USD / hour
(72 Reviews)
5.6
parsermonster

Hi there! Depending on what version of Excel you are using, this could either be drop-dead simple to implement or moderately challenging. Newer versions of Excel have a tool called Power Query that will probably be More

$30 USD / hour
(15 Reviews)
4.8
sorinacho88

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

$25 USD / hour
(34 Reviews)
4.8
SShtv

I have a lot of practical experience in Excel, including programming in VBA. This is a screenshot of one of my works. [url removed, login to view]

$25 USD / hour
(35 Reviews)
5.1