VBA macro needed for an excel spreadsheet
- or -
Post a project like this2265
$$
- Posted:
- Proposals: 11
- Remote
- #1863117
- Awarded
I am certified Microsoft Professional. I am expert Excel , VB and VB.net and Python programmer, Desktop Aplications & MS Office Integration and automation
Lahore
Excel VBA, MS PRoject Expert, Web Scraper, Arena, Simulation, Spreadsheet, Wordpress customisation
Istanbul
506661406392465822702693514703527609634511144529130044914494331963679
Description
Experience Level: Intermediate
Estimated project duration: 1 day or less
Need a macro that will do the following:
1. Look for a specific (fixed) value in a column filled with text (3,000+ rows)
2. Select that Cell and store the reference as a "Cell" variable.
2. Extract the set number of characters after the value found (16 digits) and set it as a "original ID" Variable
3. Look & replace the variable using the VLOOKUP function with a different value and set it as a new value "new ID"
4. Amend the original text in the cell (using the reference variable defined earlier) by replacing the "original ID" with "new ID".
5. Repeat the process for each result found from step 1.
Please find attached short video demonstrating how this works if done manually. Hope that helps to visualise what needs to be achieved.
1. Look for a specific (fixed) value in a column filled with text (3,000+ rows)
2. Select that Cell and store the reference as a "Cell" variable.
2. Extract the set number of characters after the value found (16 digits) and set it as a "original ID" Variable
3. Look & replace the variable using the VLOOKUP function with a different value and set it as a new value "new ID"
4. Amend the original text in the cell (using the reference variable defined earlier) by replacing the "original ID" with "new ID".
5. Repeat the process for each result found from step 1.
Please find attached short video demonstrating how this works if done manually. Hope that helps to visualise what needs to be achieved.
Artur Z.
100% (20)Projects Completed
15
Freelancers worked with
14
Projects awarded
59%
Last project
14 Jun 2023
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies