Results 1 to 4 of 4

Thread: Trying to link Excel data to a Word label template (2010)

  1. #1
    Junior Member
    Join Date
    Jun 2013
    Posts
    2
    Rep Power
    0

    Trying to link Excel data to a Word label template (2010)

    Hey all,

    I'm trying to get a label template to auto-fill with data from an excel spreadsheet. The labels are formatted so they each contain several separate text boxes. They're warning labels for chemicals, similar to this one:



    I need to make these labels for an inventory of around 550 chemicals. Obviously it would be ideal if I could somehow automate at least part of this. I know how to get an excel spreadsheet linked as an object in a word file, but is there any way I could use, for example, LOOKUP or VLOOKUP functions in a text box to get this information automatically?

    Thanks for any suggestions, I'm not looking forward to manually entering 550 sets of numbers, manufacturers, and names like "Trans-(1,2- Cyclohexylenenedintrilo)-tetraacetate Acid"

    - K
    Last edited by K_furbs; 06-26-2013 at 11:16 PM. Reason: Grammar

  2. #2
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    The first question would be, why do you necessarily need to do this label in word? If you can keep it in Excel, you could find it more easier to update the information.
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  3. #3
    Junior Member
    Join Date
    Jun 2013
    Posts
    2
    Rep Power
    0
    That.... is a valid and obvious point. I could probably make a template in another sheet, right now it's just in there because of easier formatting.

    What would be the easiest method of doing that? Setting up a LOOKUP formula is easy enough when I'm extending it throughout a table, but what about when there's multiple text boxes?

  4. #4
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    Well, you will need some unique key that links up each table. Either that, or keep all the information that you need per label in the same table, and when you select a specific key, the label will display all the relevant values from the cells in the corresponding row.
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

Similar Threads

  1. Replies: 26
    Last Post: 10-22-2019, 02:39 PM
  2. Ribbon Calendar DatePicker Word 2007-2010
    By Excel Fox in forum Download Center
    Replies: 24
    Last Post: 09-23-2013, 09:07 AM
  3. How To Use Camera Control In Excel To Paste Picture As Link
    By Transformer in forum Tips, Tricks & Downloads (No Questions)
    Replies: 0
    Last Post: 05-27-2013, 10:42 PM
  4. Data Sortin_ MS Excel 2010
    By blake85 in forum Excel Help
    Replies: 2
    Last Post: 03-01-2013, 11:37 AM
  5. Replies: 7
    Last Post: 05-09-2012, 11:34 PM

Tags for this Thread

Posting Permissions

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