Different quantities of a certain item...

[JDellenger]

I have a worksheet that I am trying to do a mail merge from to print mailing
labels. There is a column that is labeled quantity and has a list of numbers
in it.

I need to be able to print a different number of each label...based on the
number that is in the quantity column.

Is there any way that I can do this? For example, if my quantity column has
the value 3...I need to be able to print 3 labels that say "Box 1 of 3", "Box
2 of 3" and "Box 3 of 3" as one row of the merge.

Does anyone have any ideas of ways that I can maybe use multiple formulas to
do this????

Any help would be GREATLY appreciated!!!!!!!!!

[agarwaldvk]

JDellenger

This can perhaps only be realised through using VBA.

In your example, if the quantity against an item is 3, then you might want to insert (3 - 1) rows just under the row for this item. Then in a column perhaps next to the quantity column you might want to print "Box 1 of 3" in the first row of this item, "Box 2 of 3" in the second row of this item and "Box 3 of 3" in the third row of this item.

I don't know whether you want to go down this path but this in my opinion is one of the options that may be available to you!


Best regards



Deepak Agarwal