I have a Word document that I want to link up with data from an Excel
spreadsheet. For instance, say I have a sentence in a Word document like:
Last quarter the foreclosure rate fell by ____ basis points to ____ percent.
I want to fill in the blanks by using specific cells in a spreadsheet.
The data will change every month, so I thought I could automate the process
instead of keying it into the Word document. I don't know if I can even do
such a thing, let alone how do it.
Thanks for your help or directing me to the proper newsgroup or resource.
Jeannine
Bill Manville - 03 Aug 2006 00:39 GMT
In Excel: Edit / Copy the cell
In Word: Edit / Paste Special / Unformatted text / Paste Link
Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup