+ Reply to Thread
Results 1 to 3 of 3

Excel sheet with the layout from MS Word

  1. #1
    Registered User
    Join Date
    10-19-2008
    Location
    Tokyo
    MS-Off Ver
    MS Offuce 2019
    Posts
    45

    Excel sheet with the layout from MS Word

    Hello,

    I have a Word file that has the layout I want to use.

    Now I tried to copy paste the exact layout to the Excel file but the layout always get distorted.
    And I do not know how to recreate the exact layout from the Word file.

    I have attached the Word file to this post, can someone help me how I can recreate the exact layout in a Excel sheet?

    Thank you.

    PS:
    The layout is important because it will be printed out in a label paper.
    If the shape and size of the layout get distorted, I wont be able to print the label correctly.
    Attached Files Attached Files

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Excel sheet with the layout from MS Word

    Why would you want to do that ? Word is perfect for the task.

  3. #3
    Registered User
    Join Date
    10-19-2008
    Location
    Tokyo
    MS-Off Ver
    MS Offuce 2019
    Posts
    45

    Re: Excel sheet with the layout from MS Word

    Yes, but I wanted to use with the "Code 128 barcode"

    In my mind each square of the label paper should look like this.
    ---------------------------------------
    "Item number"
    "Item name"
    "Code 128 barcode"
    -----------------------------------------

    Of course I can do exactly that on the word file I attached.
    But then I would have to manually do each item over and over again. (thousand of items)
    In other words I wanted to create a Excel file which would make that faster.

    So lets say I have two sheets, sheet1 is "info" and sheet2 is "Layout".
    If I out the "Item number", "Item name" and the barcode# as a list in the sheet "info"
    All those information would automatically find it self in "Layout" sheet.
    =Info!A3 (With this I can attach what ever item name is in "A3" to the sheet "Layout")

    I have over 1000 of items and I hoped using the excel would speed the things alot.
    I have attached an example(scaned) of the end result I am hoping for.

    Is what I am hoping for possible?
    Attached Files Attached Files

+ 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. Replies: 3
    Last Post: 01-14-2015, 05:23 AM
  2. Replies: 0
    Last Post: 12-26-2012, 05:36 PM
  3. Use Excel VBA to open Word Doc in PRINT LAYOUT View
    By Marksman in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-11-2012, 02:50 AM
  4. Excel string into Word for layout changes and Print
    By D_Rennie in forum Word Programming / VBA / Macros
    Replies: 1
    Last Post: 10-31-2009, 06:22 PM
  5. In EXCEL copy sheet layout to another sheet
    By Stan in forum Excel General
    Replies: 2
    Last Post: 02-01-2006, 03:10 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