In Progress

excel mail merge into a picking sheet

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

Skills: Excel, Word

See more: picking sheet excel, want excel spread sheet, thank note sample, thank mail, sample thank note, pick job, mail merge word excel, looking job excel, job mail, ebay o, custom list excel, ask excel, excel mail, want write note, get label, word merge, sales sheet, sales excel, picking, my mail, merge data, mail merge, line sheet, want excel, hand write word

About the Employer:
( 17 reviews ) Carnwath, United Kingdom

Project ID: #1632849

Awarded to:

vserv

I have done similar work before. Pls see your messages. Thanks

$30 USD in 1 day
(56 Reviews)
5.8

16 freelancers are bidding on average $56 for this job

Krusche

Excel experts here. Check your inbox for examples.

$60 USD in 1 day
(21 Reviews)
5.2
northwolves

Ready to start.See PMB please.

$40 USD in 1 day
(38 Reviews)
4.8
Nhcuong

I can do it, Will send working demo soon. Looking forward to hearing you, Cuong NH

$40 USD in 2 days
(21 Reviews)
4.8
chriskerpini

The code you need is written and tested. Please check your PMB for details.

$40 USD in 1 day
(12 Reviews)
4.4
JovenR

Hi sir! let me handle these and I can start immediately... Thanks! J.

$40 USD in 1 day
(13 Reviews)
4.2
rohitpithisaria

Hi I would like to apply for the job posted by you. Thank you Rohit Pithisaria

$80 USD in 7 days
(10 Reviews)
3.7
vikashgadia

WE HAVE ALREADY ATTACHED COMPLETE FILE FOR YOUR USE.

$30 USD in 1 day
(15 Reviews)
3.6
muhammadsumair

Hi, I am offering my services for your project. Please check your PM.

$30 USD in 1 day
(5 Reviews)
3.5
Jinni22

Had experience in working with such documents during internship. Hope to be able to help you out in this! :)

$250 USD in 2 days
(0 Reviews)
0.0
TigerLeo

Pl check PM

$50 USD in 2 days
(0 Reviews)
0.0
sachgudiya

Hi I would like to apply for the job posted by you.

$50 USD in 3 days
(0 Reviews)
0.0
yangyang040922

new freelancer, but proficient in MS office with International Computer Driving License

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

Dear sir & Madam, I am new freelancer.com user but, I have experience of Data Entry Operator and I completed cours with certification an data entry subject. I can handle this project easily. I would like to apply for More

$49 USD in 3 days
(0 Reviews)
0.0
diligent123

Work with us and get experience of our excellent service. currently we are doing USA & AUS projects.

$40 USD in 3 days
(0 Reviews)
0.0
adolfonovais

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.

$30 USD in 5 days
(0 Reviews)
0.0