If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.
I have a word document that I use as a template to produce results reports.
I have a line of text e.g.
The results found a difference of XXXX%
This is the same for alot of sentences and details.
What I want to do is have a box pop up when I open the Word document, allow me to select an Excel spreadsheet from my desktop, and fill in the XXXX sections based on certain cell values.
The cells used for each thing will be the same from each spreadsheet even though the values will change based on the results found.
Not sure about switching workbooks but lets say your value is always in a certain cell in a certain workbook (e.g. C12).
Open up your Word Doc and the Spreadsheet and then Copy C12.
Go to your Word Doc and Paste Special > Unformatted Text and make sure Paste Link is checked. Does that help?
Linear Mode
