I am looking for someone who can take the downloaded sales history from my ebay sales in an excel sheet and produce a picking list from it with only the required information showing.
I have attached a sample spread sheet which is the format in which i receive the data. If you look at Cell 38B you will see this customer has bought a few items, i would want all of the products bought from this customer listed under the same name in a neat format.
The information i need for each customer is there
BUYER FULL NAME, PUYER POSTCODE,Custom Label (Columb N), Variation of Item (Columb AP), Quantity (Columb O), Blank Cell (So i can manually write a note)
I would be looking to have 1 line for each customer but if they have bought more than one item they can have an extra line. I would be looking to have around 30 lines per A4 page. Once this is set up all i want to do is load in the excel file and let the program do the rest, ready for me to print out and hand over to the warehouse staff to pick. If you need any more information, please ask. I may add extra functions onto this at a later date so who ever gets this job will get the extra work also. Thank you
16 freelancers are bidding on average $56 for this job
Dear, I can do this job. I'm new here at freelancer.com.au and I not have reputation, because I not have reputation I can do this job for the minimum price because I need to obtain reputation. Adolfo.