Closed

excel mail merge into a picking sheet

This project was awarded to vserv for $30 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required
Project Budget
$30 - $250 USD
Total Bids
16
Project Description

Hi,

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

Regards

Chris

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online