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

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
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,510
Messages
6,114,034
Members
448,543
Latest member
MartinLarkin

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