How can i print labels on which will be placed: the item number and
notes about it? These infos are contained in worksheet and being
changed after every delivery so it should be dynamic connection( there
may be 5 items or another time 15 items). What's mo number of
labels for each item should be equal to the amount of its pallets
which is mentioned in the same worksheet. I'm a quite newbie in this
topic so i don't know how to master it- i have a project of label,
button in which code i want place macro.

Hi Dario,
You would need to create a worksheet that you can make a selection from
You use MS Word to do the actual printing, and you would be referring in
MS Word to the column labels of your Excel worksheet, for arrangement
in printing.

Mail Merge, Printing Labels using Mail Merge with data from Excel
Location: http://www.mvps.org/dmcritchie/excel/mailmerg.htm
--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm



wrote in message ...
How can i print labels on which will be placed: the item number and
notes about it? These infos are contained in worksheet and being
changed after every delivery so it should be dynamic connection( there
may be 5 items or another time 15 items). What's mo number of
labels for each item should be equal to the amount of its pallets
which is mentioned in the same worksheet. I'm a quite newbie in this
topic so i don't know how to master it- i have a project of label,
button in which code i want place macro.

On 2 Sie, 07:49, "David McRitchie"
wrote:
Hi Dario,
You would need to create a worksheet that you can make a selection from
You use MS Word to do the actualprinting, and you would be referring in
MS Word to the column labels of your Excel worksheet, for arrangement
inprinting.

Mail Merge, *PrintingLabels using Mail Merge with data from Excel
Location: *http://www.mvps.org/dmcritchie/excel/mailmerg.htm
--
HTH,
David McRitchie, *Microsoft MVP -- Excel
My Excel Pages: *http://www.mvps.org/dmcritchie/excel/excel.htm

wrote in ...
How can i print labels on which will be placed: the item number and
notes about it? These infos are contained in worksheet and being
changed after every delivery so it should be dynamic connection( there
may be 5 items or another time 15 items). What's mo number of
labels for each item should be equal to the amount of its pallets
which is mentioned in the same worksheet. I'm a quite newbie in this
topic so i don't know how to master it- i have a project of label,
button in which code i want place macro.

I have sth like this from sb very helpful but need to copy also values
from column D as a item description and set number of labels copies
even to value in column E for each record:
Sub CommandButton1_Click()
lr=cells(rows.count,"c").end(xlup).row
for each c in range("C1:C" & lr)
If C.Value <"" Then
c.Copy Sheets("Sheet2").range("E3")
sheets("sheet2").PrintOut
End If
Next C
End sub

Can anybody help me with this?