Forum Discussion
Linking data from Word to Excel
Open the Word document where the spreadsheet will display.
Open the Excel worksheet that contains the data you want to link to the Word document. In Excel, select and copy the range of cells you want to include. If you plan to insert more columns or rows into the worksheet, select the entire worksheet.
To select the entire worksheet, select the box located in the upper left corner at the juncture of the row numbers and column letters.
In the Word document, position the cursor where you want to insert the linked table. Right-click and select Link & Use Destination Styles or Link & Keep Source Formatting under Paste Options.
Keep Source Formatting uses the formatting from the Excel workbook.
Your Excel data pastes directly into the Word document where the cursor was positioned. If changes are made to the source Excel file, the Word document updates with those changes automatically.
Hope this helps!
Ron, thanks very much for taking the time for your response. However, I'm trying to go the other way with the data. I put data into empty boxes in a blank form in Word. I then need to link Word and Excel together so that when I open a blank form in Excel and press update, the data (name, address, dates, etc.) populates into the blank boxes in Excel. Hope this explains the process more clearly. Thanks!!!
