Looking for Excel Expert to create simple Macro Tasks
£10-20 GBP
Πληρώθηκε κατά την παράδοση
Hello, we are looking for an Excel expert to create a Macro(s) for our ecommerce orders spreadsheet.
Our requirements are:
1. if sku column contains build-your-own-ps4, please shorten to BYOPS4
2. if sku column contains buildyourownxb1, please shorten to BYOXB1
3. if options column contains "Left Domin8or Button", please change "Left Domin8or Button" text to RED Color and BOLD
4. if options column contains "Right Domin8or Button", please change "Right Domin8or Button" text to RED Color and BOLD
5. if options column contains touchpad, please change "touchpad: (option)" text to BLUE color and BOLD
6. if options column contains "Razorback Maxfire Modchip", please change "Razorback Maxfire Modchip" text to RED + Underline
7. Each entry should be numbered
8. If possible, we need to wrap each entry / order so that we can print the spreadsheet in portrait format?
9. Please remove number from options column if there is no additional text
10. if options column contains "Grips", please change "Grips: (option)" text to white with black highlighting (background)
11. Once all steps have been made, create an additional seperate spreadsheet with SKU + Options, SHELL: (entry) + Grips:(entry) (*if SKU is BYOPS4) only
12. Once all steps have been made, create an additional separate spreadsheet with just Engraving -start:(entry) + Engraving Font --s-end:(entry) + Touchpad: (entry)?
Ταυτότητα Εργασίας: #18082012
Σχετικά με την εργασία
Ανατέθηκε στον:
I can change font format, update SKU column, create new sheet and wrap text About me & what I can provide - • 5 Yrs. of Experience in Excel & VBA. • Knowledge of Formatting, Graphs, Chart & Formulas. • Macro cod Περισσότερα
5 freelancers κάνουν προσφορές κατά μέσο όρο £18 για αυτή τη δουλειά
Hi, Reading your project description about writing Excel macros for your e-commerce order sheet that will abbreviate texts and change some cells format if certain conditions are met makes me feel like you have me in m Περισσότερα
Hello my name is Fares, I can get it done perfectly as you want let's chat when you are online, Thanks
Hi there, Your buyer request Got my attention and i think i can you my skills to handle your job. i have one year experience in this field. Contact me now and get your job done with less stress. Send me the requir Περισσότερα
Hai Client, I 'm in you. I have Some experience in Logo making, Icon designing, and more picture oriented tasks. I know photoshop and canvas. This is my passionate work so more quality and more res Περισσότερα