+ Reply to Thread
Results 1 to 3 of 3

Print Number of Carton Labels Needed

  1. #1
    Registered User
    Join Date
    12-09-2013
    Location
    Chicago
    MS-Off Ver
    Excel 2010
    Posts
    20

    Print Number of Carton Labels Needed

    Hi folks,

    Have not posted in a long time but I ran into a problem that I do not know the best way to approach for a solution.

    We have to ship 25 books per carton to over 2,000 stores. The number of books per store is different and is in the second column. If a store get 30 books, then we need 2 cartons.

    I need to print labels for the cartons. If there are 2 cartons, then I need 2 labels: Carton 1 of 2, Carton 2 of 2.

    I'm guessing Word and Mail merge is where I would print the labels, but I haven't a clue how to drive the data so that I can create the labels.

    Any suggestion on which way to attack this would be greatly appreciated at this time.


    Much thanks for your valuable time with this,
    Ed Wong

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166
    Hello ewong@schielegroup,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Registered User
    Join Date
    12-09-2013
    Location
    Chicago
    MS-Off Ver
    Excel 2010
    Posts
    20

    Re: Print Number of Carton Labels Needed

    Sorry,
    Wrong place to post this.

    I will repost it the correct area.

    Ed

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Shipping carton Allocation?
    By trepetti in forum Excel General
    Replies: 2
    Last Post: 08-06-2014, 10:50 AM
  2. Repeating multiple cells a set number of times to print labels
    By Jenrich in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-10-2009, 03:21 PM
  3. printing several pages with continuing carton numbers
    By cevatyildiz in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-15-2009, 03:25 AM
  4. Keep phone number fomatting from excel to print on WORD labels
    By Thelma Theiler in forum Excel General
    Replies: 2
    Last Post: 10-16-2005, 09:05 PM
  5. [SOLVED] print labels from excel with title and number
    By Ray in forum Excel General
    Replies: 1
    Last Post: 01-22-2005, 08:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1