![phoenix](https://d1a29h5kxv3oc2.cloudfront.net/dist/img/phoenix.81914efc7207f6a059bd10f5d3fd5f89.png)
Simple Macro
- or -
Post a project like this3403
£15(approx. $19)
- Posted:
- Proposals: 3
- Remote
- #706351
- Completed
Description
Experience Level: Entry
Description of excel work: All the below relates to the attached file.
Scan through column A and if a code appears any where in column E, copy and paste the values from A and B and paste into O and P, also then copy values in columns E F H I J K L M into columns Q R S T U V W X
When the scan is done it needs to see something that is BA014 (6) as BA014 so it picks the product code up only.
Extra notes:
Scan through column A and if a code appears any where in column E, copy and paste the values from A and B and paste into O and P, also then copy values in columns E F H I J K L M into columns Q R S T U V W X
When the scan is done it needs to see something that is BA014 (6) as BA014 so it picks the product code up only.
Extra notes:
![Steve J.](https://dw3i9sxi97owk.cloudfront.net/uploads/thumbs/a61795e9de9b8be728845c978a4f6f86_150x150.jpg)
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