Thread: importing data from excel into ms word

I was wondering if there is a simple way to import data from excel cells to ms word then saving the word document so if I change the excel cells again the saved word document wont change but opens up a new document.

Hope the above makes sense as I'm no good with technical jargon


Thanks in advance

The easiest way to accomplish this, without writing code, is to create a "link" between your Word and Excel documents. You will have to manually save the documents after a change but by doing so, you will be able to preserve the older and newer versions of your Word documents. Edit your Excel spreadsheet (save it) and select the items that you want to import into your Word Document. Open the existing (old) Word file, position your cursor where you want the Excel info and select "Edit", "Paste Special", "Paste Link", then "Paste as Excel Worksheet Object". Select "Save As" and rename your file so that you have an updated document under a newer name. You can control the link propeties to your preferences. Hope this helps.