1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Updating Word from Excel

Discussion in 'Business Applications' started by jughead028, Jul 16, 2012.

Thread Status:
Not open for further replies.
Advertisement
  1. jughead028

    jughead028 Thread Starter

    Joined:
    Jul 16, 2012
    Messages:
    1
    We have an Excel spread sheet generated weekly with customer details (several types of rows with different info on each row).

    I have a series of word documents that I need to keep updated from this spread sheet.

    I can't use hyperlinks as the spread sheet changes.

    Each customer will have multiple rows, with some common fields and some unique to the type of info on that row.

    I need to make a document keyed by the customer number and displaying the data relevant to that customer.

    Questions:
    1. Is it possible to update the Word document on opening with the data from the latest spread sheet which will be overwritten every week ?
    2. Can the word document use the customer number as a key to extract only the data for that customer?

    In the example word doc, I need to be able to change the company name, address, authorised officer, contact person (could be more than one of each), the classes and status and the list of assessors and their details.

    Any of this info can change from one spread sheet to another.
     

    Attached Files:

  2. draceplace

    draceplace

    Joined:
    Jun 8, 2001
    Messages:
    2,055
    Hey Jughead welcome to TSG. One solution might be to use 'Mail Merge' and recreate these Word documents based on the Excel sheet. Mail Merge if I remember does want all the information on the same row.

    The solution I would do ...Link or import spread sheet to Access and use the Reports. You really have a database and the sooner you treat it as such the easier this will be.

    FYI - Don't put real email addresses in the documents you post here.
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1061345