Forum Discussion
Update Word Doc from Excel Sheet linked to Form.
Hi. I want to update a Word document with information from an Excel Sheet that is being automatically updated from a Form.
I want every persons details on the same Word document as this is a Conflict of Interest Register for a not for profit that I work for.
All I can find is a process that makes individual word docs for each persons information and this is NOT what I need.
Please help me.
Questions and Clarifications:
Who manages this excel sheet?
Quote: "I want to update a Word document with information from an Excel Sheet that is being automatically updated from a Form."
You can use power query against the sheet that is updated from a form
and save the power query resultant sheet by copying the resultant power query resultant table and paste link it into the word document.
Everytime the original excel sheet gets updated, the power query resultant sheet will automatically update which will also automatically update the paste link on the word document.
Please don't hesitate to ask for assistance from anyone in the community on the power query and paste link questions.
Cheers
