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.
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.