Example: (refer to help47.zip)

help47.xls is a program used to print stickers.

In sheets("data_entry"),
--press 'Make Sticker'

New 'sticker sheets' are created, in the same format a
sheets("template"), according to the data entered i
sheets("data_entry").

Each 'sticker sheet' contains 24 labels in '6(vertical)x 4(horizontal)
format.

The question is:
How to specify *the no. of labels* to print. (ie. to control how man
times a lable is printed)

For example:
In sheets("data_entry"),
'1'--G5 (no. to print)
'2'--G6
'3'--G7
'4'--G8
'5'--G9
...

Desired Results:
'style1 label'-- print 1 time
'style2 label'-- print 2 times
'style3 label'-- print 3 times
...

*still keeping '6 x 4' format for each 'sticker sheet'!!

+----------------------------------------------------------------
| Attachment filename: help47.zip
|Download attachment: http://www.excelforum.com/attachment.php?postid=360669
+----------------------------------------------------------------

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com