1 to 200 printing labels

[colleen]

I currently have a worksheet with d10 having the company name f11 having "carton" _of __
I manually enter carton number of total carons. thus carton 1 of 200, print it,then change the number to 2 of 200 print it , 3 of 200 etc is there a macro i can use to do this automatic change and print. Also since i use a dot matrix printer using computer paper which i then have to cut and paste on carton can excel allow me to use sticker labels which comes in rolls? thanks colleen

[cpod]

If you put this formula in f11 and copy it down the carton number will increment:

="Carton " & ROW()-10 & " of 200"

You can then do a mail merge with MS Word which will allow you to use the sticker lables.

[Yogi Anand]

Hi Colleen:
Further to just what cpod said, yeas you can set Excel up to print sticky-back labels that come in rolls. If you are doing selective printing from you database, you may utilize mail-merge features, otherwise if you are going to do sequential printing you don't even need to get into mail-merge, you can setup your 200 (or whatever) labels in one shot.
HTH
Please post back if it works for you ... otherwise explain a little further and let us take it from there!