+ Reply to Thread
Results 1 to 2 of 2

Create 1 of n field for printing labels

  1. #1
    Registered User
    Join Date
    04-30-2015
    Location
    Birmingham,England
    MS-Off Ver
    2016
    Posts
    11

    Create 1 of n field for printing labels

    I need to print variable quantities of despatch labels from a list of data using mailmerge. The quantity of labels will vary dependant on number of boxes:

    Initial file:
    CUSTOMER ID NAME ADDRESS BOXES
    ABC123 ABC Limited High Street 3

    I can write code to multiply the lines so I get one line per label:
    CUSTOMER ID NAME ADDRESS BOXES
    ABC123 ABC Limited High Street 3
    ABC123 ABC Limited High Street 3
    ABC123 ABC Limited High Street 3

    Any ideas of how to create a field with 1 of n for the label number? e.g. 1 of 3, 2 of 3, 3 of 3 for above example.

  2. #2
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,742

    Re: Create 1 of n field for printing labels

    Try in col E (I assume that ID - A, Name - B, Address - C, Boxes - D):

    Formula: copy to clipboard
    Please Login or Register  to view this content.

    and drag it down
    Attached Files Attached Files
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

+ 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. Printing to labels
    By Dean81 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-25-2012, 05:08 AM
  2. Printing labels
    By nickcartwrightf in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-23-2009, 06:56 AM
  3. [SOLVED] Printing Labels
    By Todd Nelson in forum Excel General
    Replies: 2
    Last Post: 08-08-2005, 02:07 PM
  4. printing labels
    By paul in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-25-2005, 08:06 PM
  5. [SOLVED] Printing labels
    By Dkso in forum Excel General
    Replies: 2
    Last Post: 02-02-2005, 06: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