Macro For Extracting Data To A New Cell
- or -
Post a project like this3438
£20(approx. $25)
- Posted:
- Proposals: 6
- Remote
- #613598
- Awarded
Data scraping / data mining / data extraction / web scraping / scraping / data conversion / General admin support and more
Kent
7979389574598984139058664984665266
Description
Experience Level: Entry
General information for the business: Online Retailler
Description of excel work: We require a macro to be written so that we can install it on all our machines in the office (running excel 2010)
In the attachment you will see in row A a stock number for each of our products. It contains a location within the stock number that we need to extract. e.g:
(L) R03-140 - 2322M - The location we need to extract on this one is 'R03-140' or
(P) R23-4111 - 36696 - The location we need to extract on this one is 'R23-4111'
The location is either going to be 10 or 11 characters long.
We need a macro to be written so with one click it will extract the product location from the stock number and paste it into the 3rd column of the spreadsheet called location.
I have attached a spreadsheet for reference, if you have any further questions please be sure to contact us.
Extra notes:
Description of excel work: We require a macro to be written so that we can install it on all our machines in the office (running excel 2010)
In the attachment you will see in row A a stock number for each of our products. It contains a location within the stock number that we need to extract. e.g:
(L) R03-140 - 2322M - The location we need to extract on this one is 'R03-140' or
(P) R23-4111 - 36696 - The location we need to extract on this one is 'R23-4111'
The location is either going to be 10 or 11 characters long.
We need a macro to be written so with one click it will extract the product location from the stock number and paste it into the 3rd column of the spreadsheet called location.
I have attached a spreadsheet for reference, if you have any further questions please be sure to contact us.
Extra notes:
Steve J.
100% (50)Projects Completed
57
Freelancers worked with
47
Projects awarded
84%
Last project
27 Feb 2020
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