Word Help

[Golding]

howdy,

I'm trying to redo some of our work documents.

At present they have a normal table with numbers in it, we have to manually add up the numbers and enter the total to another cell (not spreadsheet, just section in the table) and also the front page of the document, its a PITA.

I've put in an excel spreadsheet to add up the totals and it works great, but now how do i get the total to appear on the front page?
i was thinking in a field but i cant get the flied to link to the spreadsheet?

anyway how i can do this?

cheers!

 

[Ingall]

I'm a bit confused. The title says Word but you say you're using Excel?

 

[Golding]

I'm a bit confused. The title says Word but you say you're using Excel?

Its in word, but using an excel spreadsheet.

the document is a proposals, so it outlines all the people to work on a job and add up the hours and totals. Before we had to do it manually, using the spreadsheet inside the word docuemnt its all automatic.

but i want to get the total generated in the spreadsheet to automaitcally appear at another section of the document.

 

[seanoff]

umm just copy the relevant bit and "paste special" as an excel worksheet object.


so in your case total everything up and copy the total. go into word, paste special and paste it as an excel worksheet object. done.