Find Jobs
Hire Freelancers

Excel Shop Orders

£10-20 GBP

Completed
Posted about 5 years ago

£10-20 GBP

Paid on delivery
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.
Project ID: 18641440

About the project

6 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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 in 1 day
4.9 (65 reviews)
4.5
4.5
6 freelancers are bidding on average £30 GBP for this job
User Avatar
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 in 0 day
5.0 (896 reviews)
8.0
8.0
User Avatar
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 in 3 days
4.9 (140 reviews)
7.0
7.0
User Avatar
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 in 1 day
4.7 (22 reviews)
4.4
4.4
User Avatar
sir i'm a poor boy i need work to manage my experience Relevant Skills and Experience i do all ypur work with full honesty
£18 GBP in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have gone through your requirements, and we can do this. Need to discuss on how and when the process to be done.
£23 GBP in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
Soham, United Kingdom
5.0
1
Payment method verified
Member since Feb 1, 2019

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.