+ Reply to Thread
Results 1 to 2 of 2

Populate WORD Template with data from Excel Template

  1. #1
    Registered User
    Join Date
    07-07-2019
    Location
    Pennsylvania
    MS-Off Ver
    365
    Posts
    25

    Populate WORD Template with data from Excel Template

    Okay I was going to make up qquick examples but before I do, as I suspect this will be a relativly simple answer, Here is what I am trying to do:

    -I have a WORD template that is a printable report
    -I have an EXCEL template that has 1 Sheet which EXPORTED data from a website is IMPORTED/pasted into. Sheet 2 in a manual input sheet for additional, needed info for an upcoming meeting.

    How do I link/merge/sync - the fields in the WORD Template, to the fileds in the EXCEl template - so that once data is filled into the excel templte - I can sync the Word & Excel Docs, and the WORD Template will populate all of the fileds from the excel template?

    Let me know if more info is needed or if I need to upload examples to further explain. Any assistance is greatly appreciated, and as always - Thank you in advance!

  2. #2
    Forum Guru macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,656

    Re: Populate WORD Template with data from Excel Template

    Depending on your requirements - for which you really haven't given enough detail - you could copy the Excel range(s) then paste them into Word at the relevant locations using Paste Special with the 'paste link' option and your preferred paste format. Having dome that, any changes to those ranges in the Excel workbook will be reflected in the Word document.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

+ 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. Auto Populate Word Doc from Excel (Template)
    By shouston in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-18-2019, 12:46 PM
  2. VBA Programming - populate word template with excel button
    By vixter100 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-29-2018, 12:19 PM
  3. Use Excel Data to Populate Word Template
    By laralara in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-16-2013, 08:38 AM
  4. VBA to take from excel list and populate word template
    By bruizer31 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-30-2013, 11:29 AM
  5. Macro to populate a word template and feed an excel master sheet
    By hieldy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-05-2013, 05:40 AM
  6. How to populate values in Normal.dot template or any Template file
    By csekhar.apps in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-11-2010, 01:03 AM
  7. How can I have Excel cells populate a Word label template?
    By MS Questionnairess in forum Excel General
    Replies: 1
    Last Post: 06-07-2006, 08:30 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