I need an Excel expert
- or -
Post a project like this2497
£15/hr(approx. $19/hr)
- Posted:
- Proposals: 15
- Remote
- #1549208
- Awarded
Spreadsheets|Excel macros and VBA|Google sheets |Google app scripts|Presentations - Tableau, PowerPoint, Prezi|Google data studio
Bay Minette
163048016413801642492
Description
Experience Level: Intermediate
Hi,
i require an Excel expert to help me with what would be for me an extra long data crunch session. however i imagine there sill be some way of doing this quickly.
attached is the data set i need working on. you can see in column 'A' titled 'sku' these are our part numbers. in column 'AU' titled '_media_image' is the image names for the each part number.
i am looking to apply a new image to each part number. the image files have been saved as the part number. but the person that named them used and '_' instead of a '-' which can be easily sorted with a find & replace function. please add .jpg to the end also.
the column 'AW' titled' _media_position' is the order sequence of the images. the new image is to be the last image. so it will be a 2 or a 3 depending on the number of items per product.
the column 'AX' titled '_media_disabled' this should always be 0
to give you an idea of what i am looking for i have done the part numbers that begin with letter A. FYI i do not require the last bits of the part numbers (this is sizing) so using the info above for example the next part number:-
B-200-04-02
AU = B_200.jpg
AW = 2
AX = 0
Please note that i have hidden other fields because they do must not be interfered with.
if you have any questions please ask.
i require an Excel expert to help me with what would be for me an extra long data crunch session. however i imagine there sill be some way of doing this quickly.
attached is the data set i need working on. you can see in column 'A' titled 'sku' these are our part numbers. in column 'AU' titled '_media_image' is the image names for the each part number.
i am looking to apply a new image to each part number. the image files have been saved as the part number. but the person that named them used and '_' instead of a '-' which can be easily sorted with a find & replace function. please add .jpg to the end also.
the column 'AW' titled' _media_position' is the order sequence of the images. the new image is to be the last image. so it will be a 2 or a 3 depending on the number of items per product.
the column 'AX' titled '_media_disabled' this should always be 0
to give you an idea of what i am looking for i have done the part numbers that begin with letter A. FYI i do not require the last bits of the part numbers (this is sizing) so using the info above for example the next part number:-
B-200-04-02
AU = B_200.jpg
AW = 2
AX = 0
Please note that i have hidden other fields because they do must not be interfered with.
if you have any questions please ask.
LEWIS C.
100% (2)Projects Completed
2
Freelancers worked with
2
Projects awarded
29%
Last project
18 Jun 2018
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