Excel Shop Orders

£10-20 GBP

Terminado

Publicado

hace alrededor de 5 años

£10-20 GBP

Pagado a la entrega

Hey there, We have a shop system that automatically produces a CSV file each day containing all the orders places on the website, sadly the format of this CSV file can't be changed. I was wondering is there any way in excel to make it so that column "B" could produce a report or a table based on the colour variant, and size variant of each order and add them up into a total of each product size and colour in order so that we can pick the total amount of items needed to package up each days orders instead of going through line by line adding them up each day. Problem is the variant are all in the same column, any help would be greatly appreciated.

ID del proyecto: 18641440

Información sobre el proyecto

6 propuestas

Proyecto remoto

Activo hace 5 años

¿Buscas ganar dinero?

Dirección de email

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto

Cobra por tu trabajo

Describe tu propuesta

Es gratis registrarse y presentar ofertas en los trabajos

Adjudicado a:

@arpankumarde

Hi, I have gone through the screenshot. I can make a report out of column B. I have 7 years of experience in excel Vba and formulas. I can get it done within a day. I would like to ask a few questions if awarded. Thanks, Arpan

£18 GBP en 1 día

4,9

(65 comentarios)

4,5

6 freelancers están ofertando un promedio de £30 GBP por este trabajo

@cgullapalli

HI, I am good at Excel vba and formulas. I have referred the requirement. You want to consolidate the csv file daily. So, data gets updated the quantity required for each unique combination of size and colour? Looking forward to work on the project. -Chandra

£50 GBP en 0 día

5,0

(896 comentarios)

8,0

@polarjin2017

Hello? How are you? I have good experiences in "Excel Shop Orders" as you can see my profile for these (Data Entry, Data Processing, Excel, PHP, Visual Basic). I have been working for 7 yrs in this scope. While we contract and work in our jobs, I will get paid once you have confirmed satisfied result. If I do not deliver satisfied result, I will never get paid from you. We can discuss more details to understand more easily if you have other infos. Hope to work with you. Thank you.

£55 GBP en 3 días

4,9

(140 comentarios)

7,0

@rIbrarahmed

hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I understand the value of deadline and do not compromise on quality. I feel fit myself for this project. please contact with me. Thanks.

£18 GBP en 1 día