+ Reply to Thread
Results 1 to 3 of 3

Printing Data Labels from Excel

  1. #1
    Registered User
    Join Date
    02-08-2021
    Location
    Orange County, California
    MS-Off Ver
    2010
    Posts
    9

    Question Printing Data Labels from Excel

    Hello,

    ...and my thanks to the group that, like others on the Web, provides a valuable service to those of us who are not terribly adept at figuring things out for ourselves.

    Specifically, I use a number of MS Office applications in my technical development/writing work, but not Excel. However, realizing the power available, I had a family member set up a Bill of Materials for me in Excel, which really facilitates purchasing and organizing production runs. I don't understand Excel myself, but am able to use the template that was set up for me, make changes in the various fields and use Excel for keeping track of inventory, etc.

    Now my question. Is it possible to have Excel export data for printing labels, item-by-item, showing the item number, a description of that line item, where the item is used and the total quantity? Ideally the printout could be set up for a Brady or other off-the-shelf sticky label.

    This seems like a 'natural' use for Excel, and if there's applicable software already out there, I'd get it. But before I ask this family member for help, I'd at least like to know if this is possible and how difficult it would be. If creating a usable routine is out of her league I'd try to find someone who'd be willing to set something up at modest cost. I'd be happy to share my database, along with an example of what's needed, if this already hasn't been done.

    Many thanks!

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,882

    Re: Printing Data Labels from Excel

    welcome to the forum

    For future reference, please take a moment to read the forum rules and use thread titles that are descriptive of your problem - not what you think the answer might be. (think google search terms?).

    Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

    I have changed the title for you this time, as you are new to the forum
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    02-08-2021
    Location
    Orange County, California
    MS-Off Ver
    2010
    Posts
    9

    Re: Printing Data Labels from Excel

    Ah, I get it; thanks, Alan!

+ 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. [SOLVED] Excel 2010 -- "Visual Basic" "Macros" and "Record Macro" all disabled.
    By NicholasL in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-07-2017, 06:11 AM
  2. [QUESTION/HELP-VBA/MACROS]Auto Edit Link from "Sheet1" to "Sheet2"
    By iphone3g in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 08-24-2016, 02:49 AM
  3. [SOLVED] Excel 2007: How to Convert "5/2/2013" to "May" then subtract a Month so it's "Apr"
    By Golom in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-19-2013, 02:00 AM
  4. Replies: 1
    Last Post: 09-21-2013, 03:18 AM
  5. Replies: 1
    Last Post: 11-15-2012, 01:53 PM
  6. New member for this "Excel"lent forum
    By bukhory in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 05-31-2012, 10:57 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