how to specify the no. to print?? (possible? how?)

[active_x]

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
+----------------------------------------------------------------