Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: 1 to 200 printing labels

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    61
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  2. #2
    Board Regular
    Join Date
    Apr 2002
    Posts
    124
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  3. #3
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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!
    Regards!

    Yogi Anand, D.Eng, P.E.
    Energy Efficient Building Network LLC
    www.energyefficientbuild.com

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •