![]() |
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 |
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