In Progress

MS Excel guy required for simple CSV manipulation sheet

I have a project up for grabs that should be very easy for an Excel Whizz. It is to tidy up a daily order CSV into the correct format.

Im using Office 2007....So must be in this format.

I basically want to have an XL sheet that I can open a CSV in the same instance of XL, and have it do various things to the CSV E.G.

*Delete Column B, H, L

**Change the figure in Column Q based on the data in Column C

***If a customer has ordered more than 1 item, they will be on seperate lines. I want it to put all in one line by adding columns in and custom naming the columns accordingly - totalling up the order price, and Order Quantity Total

****Put the correct Postage Service name in Column R, based on various other data.

This is just a rough outline of what is required. I will give full description and example files to the winning bidder. I expect it will be a very quick job for an Excel whizz, so please get your bids in.

I need this doing by Wednesday 13th please - so only bid if you have the time to do it before then.

Thanks

Sorry, this is open to anyone who can do it. Ignore the title stating Guy required. Female also considered equally. I was trying to sound jovial.

Thanks

Skills: Excel

See more: excel csv manipulation, what is a customer service job, ms project price, ms office project, MS Excel 2007, customer data in excel, xl, time sheet, simple csv, price excel, name naming, ms-excel, ms excel, line sheet, Guy, format excel, excel service, correct csv, quick excel, sheet excel job, required description, rough guy, excel required csv, csv column format, excel tidy data

About the Employer:
( 22 reviews ) London, United Kingdom

Project ID: #1121806

Awarded to:

UmarMahmood

Please see PM for more details.

$75 USD in 1 day
(23 Reviews)
4.3

8 freelancers are bidding on average $41 for this job

mrbrave

Ready to start now...

$35 USD in 1 day
(77 Reviews)
5.4
microk

Let's start..

$35 USD in 1 day
(17 Reviews)
4.2
GoodResults

Hi, I am interested. Thanks

$30 USD in 1 day
(22 Reviews)
4.1
SilviaT

Please check PM.

$50 USD in 2 days
(5 Reviews)
2.4
sekhar020

I have done this project before. Thank You

$40 USD in 1 day
(0 Reviews)
0.0
sapphiremoarun

I can assure you that the work will be finished at the earliest

$35 USD in 1 day
(0 Reviews)
0.0
nazibul007

sir, i'm fast,hardworking person & i'm ready to do your job right now.i'm waiting for your reply

$30 USD in 1 day
(0 Reviews)
0.0