I'm not sure this is possible. Anyways, here is what I am trying to accomplish.

I have a word document that is populated using reference links from an excel file. Part of this document is a breakdown of the economic conditions at the time, which is dependent on what date is entered into my excel file. The economic conditions write ups are produced quarterly and stored in a separate word file. We currently manually copy and paste the text from the apropriate file into our document.

So for instance, if the date entered into the excel file is January 31, 2013, we would currently manually enter the text from the Q1 - 2013 word document we have saved in a separate file. If the date was November 30, 2012, we would copy and paste the text from the Q4 - 2012 word document and so on.

My question ultimately is, is there anyway to populate the text from the Q1-2013 word document into our linked word document based on the input in the excel file?

What I would like to happen is the user can put in a date, and based on the date, the text of the quarterly economic conditions word document be updated in our linked word document?

The text in the quarterly word docs is far too long to attempt to re-type into a concatenation formula.

I hope this makes sense, however I'm not sure it's possible.

Any help is greatly appreciated!

Thanks!

JM

Yes I think it is possible. It iis not clear if you are working from Excel or Word. However, look up INCLUDETEXT for Word.

Say you are working in Excel (as in you generate the Word document from Excel). You get the date from whatever input in Excel. Using some sort of logic, e.g.

January 31, 2013 means use the Q1 - 2013 word document

if the text in the Q1 - 2013 word document is bookmarked, you can use INCLUDETEXT to insert that bookmarked text into any document you like.

To link to an Excel file, you'd use a LINK field. Simply copying & pasting from Excel, using 'paste special' with the 'paste link' option will give you both the link and a choice of paste formats.

The key to the method's success in this case is to not expect Word to find a different set of cells for each period; if necessary, create an output sheet with whatever linking formulae are required to retrieve the data of interest into a set of cells that can be used for any month.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Duplicate post at: https://www.msofficeforums.com/excel...o-another.html
Please don't post the same question in multiple forums.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]