1 to 200 printing labels

colleen

Board Regular
Joined
Feb 21, 2002
Messages
61
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
 

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.
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.
 
Upvote 0
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!
 
Upvote 0

Forum statistics

Threads
1,213,567
Messages
6,114,342
Members
448,570
Latest member
rik81h

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top