En cours

Word / Excel Macro Mail Merge thing for agihcam

The object of this is to create some price labels in a word document from data in an excel sheet

See attached Price label template – there needs to be 40 of these per page 10 rows of 4

They need to take the following

1) Description from Order Sheet (column B) - max 3 rows on price label with each row no more than 14 characters with each row centred. If description is longer than 42 characters trim at that.

2) Price – Retail price needs to be added in to the “Order Sheet” from the Master Spreadsheet Column M, as a new column in between column C/D

3) SKU – taken from column A of Order Sheet

Font styles and sizes need to be as per the template

This needs to be reusable e.g. we will have a new order sheet and need to generate new price labels each month

Most orders will be around 400 lines e.g. 10 pages of labels

See attached docs - the label template shows 4 of the same label - we only need one of each individual label so 40 lines of stock = 40 different prices labels on one sheet

Compétences : Excel, Word

Voir plus : mail merge excel word macro, we excel, thing 1 template, mail merge word from excel, mail merge macro, excel mail merge to word, excel mail merge template, excel mail merge macro, excel macro to word, new excel, excel spreadsheet to labels, create macro in word, master excel, g mail e mail, word merge, word excel, word docs, word /excel, Trim, row b, reusable, price excel, one thing, merge data, mail merge

Concernant l'employeur :
( 6 commentaires ) Auckland, New Zealand

N° du projet : #1014370

Décerné à :

agihcam

Please check PMB for more details.

120 $ NZD en 2 jours
(38 Commentaires)
5.1

31 freelance ont fait une offre moyenne de 94 $ pour ce travail

mrbrave

Hello.. Please check your PMB for my sample.. Thanks

150 $ NZD en 1 jour
(72 Commentaires)
5.3
RajHeartbeat

Hello sir, I'm ready to start. I will work until you get 101% satisfaction..!

60 $ NZD en 1 jour
(29 Commentaires)
5.3
ineedWorkJob

sir plz check pm !

120 $ NZD en 1 jour
(18 Commentaires)
4.8
muthumuni

Hi I am ready for it...

40 $ NZD en 1 jour
(6 Commentaires)
3.5
sjestuista

please check pmb

50 $ NZD en 5 jours
(5 Commentaires)
3.1
oFAZo

Exceptional quality & Quick work. Please refer to Profile & Reviews for details. Thanks FAZ

150 $ NZD en 2 jours
(9 Commentaires)
3.1
sTdwares

Hello. Please check your PMB before making a decision. I am sure you will be happy to work with me. Thanks (:

80 $ NZD en 3 jours
(2 Commentaires)
1.9
MIHAICIOATA

MsOffice Expert!

50 $ NZD en 1 jour
(2 Commentaires)
1.6
Vladf0

Hello,sir!Please check PM!

40 $ NZD en 1 jour
(2 Commentaires)
0.5
xbk129

Hi!it would be nice to work with you.I am willing to do this type of job. Hoping you choose my bid... thanks..

150 $ NZD en 5 jours
(0 Commentaires)
0.0
Mulerael

Am confident of handling this task if given a chance.

30 $ NZD en 6 jours
(0 Commentaires)
0.0
gufran675

Dear sir, I'll complet this project within 2 days, so please give me this project. Thanks & Best regards

75 $ NZD en 2 jours
(0 Commentaires)
0.0
desin007

I'm able and willing to work.

120 $ NZD en 1 jour
(0 Commentaires)
0.0
Rakeshkmrsharma

Hi ... Please check PM for details.

30 $ NZD en 0 jours
(0 Commentaires)
1.9
junehortilano

Please do hire me. I can do the job.

240 $ NZD en 7 jours
(0 Commentaires)
0.0
dhruvsg

Please refer PM.

90 $ NZD en 1 jour
(0 Commentaires)
0.0
RichL

With 10 years experience of excel macros (VBA), I could do this no problem

50 $ NZD en 1 jour
(0 Commentaires)
0.0
Kepz

I can do the required work in a day. I would like an extra day to recheck my work because this would be my first bid. I suggest it would be much easier to keep labels within excel instead of linking data to Word. Ple Plus

110 $ NZD en 2 jours
(0 Commentaires)
0.0
Saeed2000

Hello Sir, please check PMB. Thanks

50 $ NZD en 2 jours
(0 Commentaires)
0.0
popek6

ready for work

80 $ NZD en 5 jours
(0 Commentaires)
0.0