Forum Discussion
Victoria_Airotciv
Feb 05, 2024Copper Contributor
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 Con...
Yea_So
Apr 09, 2024Bronze Contributor
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