Excel Ref. Inside a Word Doc

[filthepitome]

All,

I do not even know what to call this, or what to search for, but this is what I need to do. I have a word document that has a summary sections with things like

Total Spend = x
Total # of Claims = x

And as of right now these numbers are manually entered from looking at an embedded excel sheet in the same word document. My question, can I reference a specific cell in the excel sheet to populate a form field, merge field, etc in the body of the word document? Even if I have to reference the original excel (.xls) file that would work too. I tried to do it with a mail merge but no luck.

TIA

 

[macropod]

Hi filthepitome,

If you copy an Excel cell/range, then switch to Word and use Edit|Paste Special and check the 'link' button, you can paste the Excel data into Word in a variety of formats.

With the 'link' button checked, the value in the Word document will update to refelct changes in the Excel workbook.

Cheers

[MS MVP - Word]