En cours

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

Compétences : Excel, Word

Voir plus : picking sheet excel, want excel spread sheet, thank you note sample, thank you mail, staff me up, sample thank you note, pick a job for me, mail merge word from excel, looking for job at excel, job mail, excel mail merge to word, ebay o, custom list in excel, ask excel, excel mail, ebay.o, want to write a note, i need sales staff, get the label, word merge, sales sheet, sales excel, picking, my mail, merge data

Concernant l'employeur :
( 18 commentaires ) Carnwath, United Kingdom

N° du projet : #1632849

Décerné à :

vserv

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

30 $ USD en 1 jour
(56 Commentaires)
5.8

16 freelance ont fait une offre moyenne de 56 $ pour ce travail

Krusche

Excel experts here. Check your inbox for examples.

60 $ USD en 1 jour
(21 Commentaires)
5.2
northwolves

Ready to [url removed, login to view] PMB please.

40 $ USD en 1 jour
(38 Commentaires)
4.8
Nhcuong

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

40 $ USD en 2 jours
(21 Commentaires)
4.8
chriskerpini

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

40 $ USD en 1 jour
(12 Commentaires)
4.4
JovenR

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

40 $ USD en 1 jour
(13 Commentaires)
4.2
rohitpithisaria

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

80 $ USD en 7 jours
(10 Commentaires)
3.7
vikashgadia

WE HAVE ALREADY ATTACHED COMPLETE FILE FOR YOUR USE.

30 $ USD en 1 jour
(15 Commentaires)
3.6
muhammadsumair

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

30 $ USD en 1 jour
(5 Commentaires)
3.5
Jinni22

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

250 $ USD en 2 jours
(0 Commentaires)
0.0
TigerLeo

Pl check PM

50 $ USD en 2 jours
(0 Commentaires)
0.0
sachgudiya

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

50 $ USD en 3 jours
(0 Commentaires)
0.0
yangyang040922

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

40 $ USD en 1 jour
(0 Commentaires)
0.0
krystynagrenda

Dear sir & Madam, I am new [url removed, login to view] 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 Plus

49 $ USD en 3 jours
(0 Commentaires)
0.0
diligent123

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

40 $ USD en 3 jours
(0 Commentaires)
0.0
adolfonovais

Dear, I can do this job. I'm new here at [url removed, login to view] 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 en 5 jours
(0 Commentaires)
0.0