MS Excel guy required for simple CSV manipulation sheet

已完成 已发布的 Jul 6, 2011 货到付款
已完成 货到付款

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

Excel

项目ID: #1121806

关于项目

8个方案 远程项目 活跃的Jul 9, 2011

授予:

UmarMahmood

Please see PM for more details.

$75 USD 在1天内
(23条评论)
4.3

有8名威客正在参与此工作的竞标,均价$41/小时

mrbrave

Ready to start now...

$35USD 在1天里
(77条评论)
5.4
microk

Let's start..

$35USD 在1天里
(17条评论)
4.2
GoodResults

Hi, I am interested. Thanks

$30USD 在1天里
(22条评论)
4.1
SilviaT

Please check PM.

$50 USD 在2天内
(5条评论)
2.4
sekhar020

I have done this project before. Thank You

$40USD 在1天里
(0条评论)
0.0
sapphiremoarun

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

$35USD 在1天里
(0条评论)
0.0
nazibul007

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

$30USD 在1天里
(0条评论)
0.0