ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Links and Linking in Excel (https://www.excelbanter.com/links-linking-excel/)
-   -   Use Excel cell values in a Word document (https://www.excelbanter.com/links-linking-excel/102743-use-excel-cell-values-word-document.html)

Jeannine

Use Excel cell values in a Word document
 
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

Use Excel cell values in a Word document
 
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



All times are GMT +1. The time now is 01:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com