Looking for Excel Expert to create simple Macro Tasks

Ολοκληρωμένο Αναρτήθηκε Πριν 5 χρόνια Πληρώθηκε κατά την παράδοση
Ολοκληρωμένο Πληρώθηκε κατά την παράδοση

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)?

Excel Visual Basic Visual Basic για Εφαρμογές

Ταυτότητα Εργασίας: #18082012

Σχετικά με την εργασία

5 προτάσεις Απομακρυσμένη εργασία Ενεργό Πριν 5 χρόνια

Ανατέθηκε στον:

srijanagrawal21

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 Περισσότερα

£18 GBP σε 1 μέρα
(23 Αξιολογήσεις)
3.8

5 freelancers κάνουν προσφορές κατά μέσο όρο £18 για αυτή τη δουλειά

dvcontact

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 Περισσότερα

£20 GBP σε 1 μέρα
(48 Αξιολογήσεις)
6.3
dev7fares

Hello my name is Fares, I can get it done perfectly as you want let's chat when you are online, Thanks

£23 GBP σε 10 μέρες
(1 Κριτική)
0.5
sunainamzhr

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 Περισσότερα

£18 GBP σε 1 μέρα
(0 Αξιολογήσεις)
0.0
manojkmr2197

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 Περισσότερα

£13 GBP σε 7 μέρες
(0 Αξιολογήσεις)
0.0