Here's how I do it:

In Excell, select cell containing desired subtotal
copy
In Word, place cursor in desired location
Edit-Paste Special-Select Link and As Unformatted Text
click OK

Your subtotal (formatted in whatever number format you have applied to
it in Excel), should now be shown in the middle of the sentence. I'm
not sure how Word knows when to update the links, but sometimes I have
to work a few tricks (close and reopen the document, for example) to
make sure Word is using the latest value from Excel, but it should work
well for you.


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=400815