Printing labels

D

Dkso

I have an Excel spreadsheet that uses a query to get info from the database,
this info is held in a list, each item is a replenishment available to be
done. I want to be able to re-produce this list on a separate sheet but 4
at a time so they can be printed on sticky labels.
Using a straight forward cell reference I have the fist 4 items but I can't
figure out how to move the cell reference down by 4 so as to print the next
4.

Am I going about it the long way?
The list will change in length so I'll need to check and stop at the end of
the list.

Ideas or help appreciated.

Dean
 
R

RagDyer

You're *definately* going about it the "long" way.

All you need is a standard XL datalist, and then use Word to do the
formatting and printing of the actual labels.
All you need to know can be found at David McRitchie's extensive web page on
the subject.

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

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


I have an Excel spreadsheet that uses a query to get info from the database,
this info is held in a list, each item is a replenishment available to be
done. I want to be able to re-produce this list on a separate sheet but 4
at a time so they can be printed on sticky labels.
Using a straight forward cell reference I have the fist 4 items but I can't
figure out how to move the cell reference down by 4 so as to print the next
4.

Am I going about it the long way?
The list will change in length so I'll need to check and stop at the end of
the list.

Ideas or help appreciated.

Dean
 
Top