more-arw search

Q&A Forum

Pulling Data from an Excel sheet into a Word Document

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.

Answers

Topic Expert
Wayne Spivak
Title: President & CFO
Company: SBAConsulting.com
LinkedIn Profile
(President & CFO, SBAConsulting.com) |

Why not cut and paste special (link).

This way if you change the underlying sheet, the Word doc is automatically updated.

Anonymous
(Director of Finance) |

How easy is it to update the links to the subsequent workbook each period moving forward?

Topic Expert
Wayne Spivak
Title: President & CFO
Company: SBAConsulting.com
LinkedIn Profile
(President & CFO, SBAConsulting.com) |

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.....

258 views

Get Free Membership

By signing up, you will receive emails from Proformative regarding Proformative programs, events, community news and activity. You can withdraw your consent at any time. Contact Us.

Business Exchange

Browse the Business Exchange to find information, resources and peer reviews to help you select the right solution for your business.

Learn more

Contribute to Community

If you’re interested in learning more about contributing to your Proformative community, we have many ways for you to get involved. Please email content@proformative.com to learn more about becoming a speaker or contributing to the blogs/Q&A Forum.