+ Reply to Thread
Results 1 to 2 of 2

Printing Formula based Quantity of Labels

  1. #1
    Registered User
    Join Date
    07-06-2012
    Location
    Mumbai
    MS-Off Ver
    MS Office Home & Student 2019
    Posts
    7

    Printing Formula based Quantity of Labels

    Hi all.

    I am producing product detail labels as per demo excel file attached.

    I print it on Full A4 Size Label Sheet and then manually cut the labels to fix each label on the product packets.

    Normally, it is 21 labels per sheet on A4 (3 x 7). If MATERIAL NAME is short (single line), then it could be 24 labels per sheet (3 x 8).

    I need below help :

    (1) As of now, the PRINTING AREA Sheet shows full sheet populated. So while printing I have to manually select the no. of labels required (Cells, in multiple of 3). i.e. for eg. If I need to just 13 labels, I have to select and print upto 15 labels (3 x 5). In the LabelDATA Sheet – Cell A13 shows label qty required. Is it possible by any excel FORMULA that the PRINTING AREA Sheet populate exactly 13 labels (easy to print, without manual count n select print area)

    (2) Is it possible by any excel FORMULA that part of the merged cells, be printed in BOLD.
    =LabelDATA!A2&" : "&LabelDATA!B2
    Only Cell B2 (Mat. Code NUMBER) gets printed in BOLD

    NOTE : I use basic Excel and not aware of VBA / Macro.

    Thank you for any help.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    10-15-2022
    Location
    New Mexico
    MS-Off Ver
    2021
    Posts
    2

    Re: Printing Formula based Quantity of Labels

    Print a Single Label or a Page of the Same Labels
    Go to the Mailings tab.
    In the Create group, select Labels.
    Select Options to open Label Options.
    Choose the label brand in the Label Vendors for thermal printer, then select the product number matching the labels you want to print on.
    Select OK.

+ 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. Formula that finds the proper combination based on a certain quantity
    By ayns123 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-18-2018, 05:55 PM
  2. [SOLVED] Formula to works out Full box Quantity and Part box quantity as well,
    By pmw19800 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-13-2018, 08:59 AM
  3. Dynamic cell formula based on quantity entry
    By MICowboy13 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-21-2015, 11:11 AM
  4. Printing PDF files Quantity in Excel
    By Thekratos in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-27-2014, 05:32 PM
  5. Replies: 5
    Last Post: 08-10-2011, 05:06 PM
  6. Replies: 5
    Last Post: 11-23-2009, 06:24 PM
  7. printing only things w quantity
    By twychopen in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-03-2007, 10:12 PM

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