Word - Calculate and paste values from Excel sheet

[Augf87]

Hi. My situation is this:

I have a Word document, where I write down some numbers. To get these
numbers, I need to open an Excel sheet, and calculate them using some primary
values and functions I already have, then copying them. What I'd like to do,
is just writing down the primary values in the Word document and have
automatically calculated the resulting numbers by word, without the
copy-paste proccess that I always do.
I have read about linking sheets or macros, but I haven't got a clear idea
of what to do.

Hope it is clear. Thanks in advance

 

[Bob I]

Have you looked at Insert, Field, Formula?

 

[Beth Melton]

Depending on the layout of your document you could insert (embed) an Excel
workbook in your Word document and enter your numbers and formulas in the
embedded workbook.

If you are using Word 2007 you'll find "Excel Spreadsheet" on the Insert tab
under Tables. For previous versions use Insert/Object.

~Beth Melton
Microsoft Office MVP