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.
63 freelancers are bidding on average $31/hour for this job
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
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
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
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