Excel Shop Orders

£10-20 GBP

Dokončeno

Zveřejněno

před více než 5 roky

£10-20 GBP

Zaplaceno při doručení

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.

IČ projektu: 18641440

O projektu

6 nabídky

Vzdálený projekt

Aktivní před 5 roky

Chcete si vydělat nějaké peníze?

E-mailová adresa

Výhody podávání nabídek na Freelancer

Stanovte si rozpočet a časový rámec

Získejte za svou práci zaplaceno

Načrtněte svůj návrh

Registrace a podávání nabídek je zdarma

Uděleno:

@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 v 1 dni

4,9

(65 recenze)

4,5

6 freelanceři nabízejí v průměru £30 GBP za tuto práci

@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 v 0 dni

5,0

(896 recenze)

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 v 3 dnech

4,9

(140 recenze)

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 v 1 dni