Đang Thực Hiện

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

Kỹ năng: Excel, Word

Xem thêm: 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

Về Bên Thuê:
( 17 nhận xét ) Carnwath, United Kingdom

Mã Dự Án: #1632849

Đã trao cho:

vserv

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

$30 USD trong 1 ngày
(56 Đánh Giá)
5.8

16 freelancer đang chào giá trung bình $56 cho công việc này

Krusche

Excel experts here. Check your inbox for examples.

$60 USD trong 1 ngày
(21 Đánh Giá)
5.2
northwolves

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

$40 USD trong 1 ngày
(38 Đánh Giá)
4.8
Nhcuong

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

$40 USD trong 2 ngày
(21 Đánh Giá)
4.8
chriskerpini

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

$40 USD trong 1 ngày
(12 Đánh Giá)
4.4
JovenR

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

$40 USD trong 1 ngày
(13 Đánh Giá)
4.2
rohitpithisaria

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

$80 USD trong 7 ngày
(10 Đánh Giá)
3.7
vikashgadia

WE HAVE ALREADY ATTACHED COMPLETE FILE FOR YOUR USE.

$30 USD trong 1 ngày
(15 Đánh Giá)
3.6
muhammadsumair

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

$30 USD trong 1 ngày
(5 Đánh Giá)
3.5
Jinni22

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

$250 USD trong 2 ngày
(0 Đánh Giá)
0.0
TigerLeo

Pl check PM

$50 USD trong 2 ngày
(0 Đánh Giá)
0.0
sachgudiya

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

$50 USD trong 3 ngày
(0 Đánh Giá)
0.0
yangyang040922

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

$40 USD trong 1 ngày
(0 Đánh Giá)
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 Thêm

$49 USD trong 3 ngày
(0 Đánh Giá)
0.0
diligent123

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

$40 USD trong 3 ngày
(0 Đánh Giá)
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 trong 5 ngày
(0 Đánh Giá)
0.0