Is there an easy way to pull numerical data from an Excel workbook into a Word document. I am looking to pull from our Excel financial reports into a MD&A word document instead of cutting and pasting or re-inputting data.
Pulling Data from an Excel sheet into a Word Document
Answers
Why not cut and paste special (link).
This way if you change the underlying sheet, the Word doc is automatically updated.
How easy is it to update the links to the subsequent workbook each period moving forward?
If you are adding columns to your spreadsheet you'd have to remake the link.
Why not make your doc, convert it to pdf. Convert the excel sheets to pdf and insert where needed.....