Færdiggjort

Looking for Excel Expert to create simple Macro Tasks

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

Evner: Excel, Visual Basic, Visual Basic for Apps

Se mere: excel macro examples download, excel macro tutorial for beginners, excel macros for dummies, examples of macros in excel, how to create a macro in excel 2016, excel macro tutorial pdf, useful excel macros, macros in excel for beginners, create simple hello world component joomla, excel simple macro data comparing copy, create simple excel php, can create simple data input macro excel 2007, excel create html macro, create internet macro excel, create simple project excel, excel vba create installer macro, create installer macro excel, create simple database excel, create simple xml excel, create simple print macro excel

Om arbejdsgiveren:
( 115 bedømmelser ) Harpenden, United Kingdom

Projekt ID: #18082012

Tildelt til:

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 Flere

£18 GBP på 1 dag
(2 bedømmelser)
1.4

6 freelancere byder i gennemsnit £18 på dette job

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 Flere

£20 GBP på 1 dag
(32 bedømmelser)
5.5
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 in 10 dage
(1 bedømmelse)
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 Flere

£18 GBP på 1 dag
(0 bedømmelser)
0.0
redmapple3

hi dear. i read your description. please contact me. i can solve your problem with my skill in time. i am looking for you. kind regards.

£16 GBP på 1 dag
(0 bedømmelser)
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 Flere

£13 GBP in 7 dage
(0 bedømmelser)
0.0