Create Excel Macro, to generate output file. Very URGENT

Completado Publicado hace 5 años Pagado a la entrega
Completado Pagado a la entrega

See the sample file. I need that everytime I run macro, it creates an output excel file as follows:-

Each listing will be repated 11 times. What I need the in excel output is as follows:

1) From sample file Column B (Title) - Output File Column A (Title)

2) From sample file Column C (Description) - Output File Column B (Description)

3) From sample file Column D (Price) - Output File Column C (Price)

4) From sample file Column E-I (Images) - Output File Column D-H (Images)

5) New column in output file Column I: Ring Size: start from 4.5 and go to 9.5. Like 4.5,5,5.5,6 until 9.5

6) New column in output file Column J: MPN: for all 11 variations of the item, mpn will be same. So it will start with RHJGJmpn1 (so all 11 variations for 1st item will have RHJGJmpn1), then 2nd item will have RHJGJmpn2 etc

7) New column in output file column K: Primary: This will have a value of NO for all values, except for the row where ring size is 7, for which the value will be Yes

8) From sample file Column K-R - Output File Column L-S (repeat all values 11 times)

I am attaching a data file, for you to try and create macro to generate an output

This is very urgent work. I need it done within next few hours.

Excel Macros

Nº del proyecto: #18519985

Sobre el proyecto

4 propuestas Proyecto remoto Activo hace 5 años

Adjudicado a:

rickygzz85

I have more than 20 years of experience using Excel to its maximum capabilities. I can create your project within the next two hours. - Availability to work full time on this project, to meet the deadline. - Your s Más

$20 USD en 1 día
(2 comentarios)
1.3

4 freelancers están ofertando un promedio de $31 por este trabajo

lightingdavid

Hello? How are you? I have good experiences in "Create Excel Macro, to generate output file. Very URGENT" as you can see my profile for these (Excel Macros). I have been working for 7 yrs in this scope. While we co Más

$55 USD en 3 días
(1 comentario)
2.5
nvchien94

Hello sir, I am Chien, an Excel Macro expert. I write this because I can do this task for you. I have created many Excel macro in my previous project. Contact me and I will give you my priority and we can start now Más

$20 USD en 1 día
(3 comentarios)
1.9