software

Hi, i've tried to do it, search through books and URL but couldn't find the
answer. Hope you guys can help.

I need to print labels to stick onto my packaging.

The conventional way is to have 4 labels in 1 sheet, then i print out 100
sheets and cut them out to make 400 labels and i have to write the number
from 1 to 400. It's very time consuming.

I was thinking is it possible to do it in excel such that i only have 1
label, then enter some formula, and when i print, it will auto print out the
quantity and the running number for me.

Hi Eric,

Try this solution:

Create a workbook with 2 sheets!
On Sheet1

A B
1 Start with: Enter here the number you want to start numbering
with
2 No of Labels: Enter here the number of labels you want to printOn sheet2

A1 blank B1 = A1 1
A2 = B1 1 B2 = A2 1

Resize these 4 cells to fill a page, format them as you like,

Apply this macro:Sub LabelPrint()
Sheets(quot;Sheet2quot;).Select
For p = Sheets(quot;Sheet1quot;).Range(quot;B1quot;) To Sheets(quot;Sheet1quot;).Range(quot;B1quot;)
Sheets(quot;Sheet1quot;).Range(quot;B2quot;) - 1 Step 4
Range(quot;A1quot;) = p
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Next p
End Sub

Assign a hot key to the macro in Tools/Macros/Others(bottom push button)!

Regards,
Stefi?ricHiew??ezt ?rta:

gt; Hi, i've tried to do it, search through books and URL but couldn't find the
gt; answer. Hope you guys can help.
gt;
gt; I need to print labels to stick onto my packaging.
gt;
gt; The conventional way is to have 4 labels in 1 sheet, then i print out 100
gt; sheets and cut them out to make 400 labels and i have to write the number
gt; from 1 to 400. It's very time consuming.
gt;
gt; I was thinking is it possible to do it in excel such that i only have 1
gt; label, then enter some formula, and when i print, it will auto print out the
gt; quantity and the running number for me.

Hi Stefi

Had been spending sometimes to figure out your solution.
Manage understand and print out the labels the way i want it to print.
Thanks a million.

Cheers~~

quot;Stefiquot; wrote:

gt; Hi Eric,
gt;
gt; Try this solution:
gt;
gt; Create a workbook with 2 sheets!
gt; On Sheet1
gt;
gt; A B
gt; 1 Start with: Enter here the number you want to start numbering
gt; with
gt; 2 No of Labels: Enter here the number of labels you want to print
gt;
gt;
gt; On sheet2
gt;
gt; A1 blank B1 = A1 1
gt; A2 = B1 1 B2 = A2 1
gt;
gt; Resize these 4 cells to fill a page, format them as you like,
gt;
gt; Apply this macro:
gt;
gt;
gt; Sub LabelPrint()
gt; Sheets(quot;Sheet2quot;).Select
gt; For p = Sheets(quot;Sheet1quot;).Range(quot;B1quot;) To Sheets(quot;Sheet1quot;).Range(quot;B1quot;)
gt; Sheets(quot;Sheet1quot;).Range(quot;B2quot;) - 1 Step 4
gt; Range(quot;A1quot;) = p
gt; ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
gt; Next p
gt; End Sub
gt;
gt; Assign a hot key to the macro in Tools/Macros/Others(bottom push button)!
gt;
gt; Regards,
gt; Stefi
gt;
gt;
gt; ?ricHiew??ezt ?rta:
gt;
gt; gt; Hi, i've tried to do it, search through books and URL but couldn't find the
gt; gt; answer. Hope you guys can help.
gt; gt;
gt; gt; I need to print labels to stick onto my packaging.
gt; gt;
gt; gt; The conventional way is to have 4 labels in 1 sheet, then i print out 100
gt; gt; sheets and cut them out to make 400 labels and i have to write the number
gt; gt; from 1 to 400. It's very time consuming.
gt; gt;
gt; gt; I was thinking is it possible to do it in excel such that i only have 1
gt; gt; label, then enter some formula, and when i print, it will auto print out the
gt; gt; quantity and the running number for me.