R
Richard Cavell
Hi. I have a Word document and an Excel document. Some of the
content of the Word document merely duplicates the content of the
Excel document. What I would like to do is to set up the Word
document so that it automatically retrieves the text from the Excel
document. Similar to doing a '=D5' in an Excel spreadsheet, so that
it just harvests the contents of a particular cell (in this case, D5)
and transplants it to another place.
Is there a way to implant text from the Excel spreadsheet (which is in
another file) into the Word document, so that it automatically opens
the Excel spreadsheet in the background and harvests the correct
text? Or is there a way to insert the Excel sheet into my Word
document?
I have tried Insert menu->Object, but Word simply tries to squish the
whole sheet down onto a single page, which makes it unprintable and
unusable. And it still doesn't allow me to extract the content of
individual cells within the Word text.
Thanks in advance,
Richard
content of the Word document merely duplicates the content of the
Excel document. What I would like to do is to set up the Word
document so that it automatically retrieves the text from the Excel
document. Similar to doing a '=D5' in an Excel spreadsheet, so that
it just harvests the contents of a particular cell (in this case, D5)
and transplants it to another place.
Is there a way to implant text from the Excel spreadsheet (which is in
another file) into the Word document, so that it automatically opens
the Excel spreadsheet in the background and harvests the correct
text? Or is there a way to insert the Excel sheet into my Word
document?
I have tried Insert menu->Object, but Word simply tries to squish the
whole sheet down onto a single page, which makes it unprintable and
unusable. And it still doesn't allow me to extract the content of
individual cells within the Word text.
Thanks in advance,
Richard