Excel alone is poorly suited for creating labels.

Do you have Word?

Use Word's mailmerge with Excel or Access as the data source.

Assuming you are using Word for the mailmerge and Excel for the source see these
sites for help.

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

http://www.mvps.org/word/FAQs/MailMe...AMailMerge.htm

http://www.mvps.org/word/FAQs/MailMe...DataSource.htm


Gord Dibben MS Excel MVP

On Fri, 18 Apr 2008 23:48:02 -0700 (PDT), Bassman wrote:

Hello everyone,
I am trying to make labels for warehouse product showing product
numbers and locations from an placed order. I have a worksheet with
part number, location, and qty in seperate collums. I can setup the
merge to print one copy of each part ordered,no problem, how can I
have multi labels print for an entry if qty is greater than 1? Right
now it will print one label showing qty of 25. This order is very
large. I know I can copy and insert 24 row with the same part number/
location and it will merge but can it be automated to take the qty and
print out what ever is needed and then move to the next row/part
number. I am learning excel on my own and with the dummy's book. lol

Thanks in advance