Linking a sheet's content into a Word document

  • Thread starter Thread starter Richard Cavell
  • Start date Start date
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
 
Is there a way to implant text from the Excel spreadsheet (which is in
Click to expand...

Sorry that I neglected to mention... my document(s) may be used by
people using oldish versions of Office, so I'd prefer a solution that
doesn't rely on using the latest version. Thanks,

Richard
 
Back
Top