Reference mulitple excel tables in a single word doc

[cerpika]

Hello, I have a relatively simple question that I can not figure out. Hopefully someone here can help me!

I have a word doc that has several Excel worksheets inserted into it. I actually only use each worksheet for a single value each. But I use separate worksheets because these 'boxes' need to be in different places in the word doc.

The last excel worksheet needs to use values from the other worksheets in the doc. However, I do not know how to make the cell in the last worksheet pull the values from the other worksheets in order to make the calculation it needs to.

Does this make sense?

TIA,

Cerpika

[NukedWhale]

I'm having difficulty understanding your problem, but I'm a beginner. Perhaps you can better clarify it?

[cerpika]

Hopefully this will make it a bit clearer. Thanks for taking a look at this.

I have a word document that is comprised of about 5 paragraphs of text. At the end of each paragraph, I leave a spot for a colleague to place a number from 1 to 5 (to rank the paragraph for accuracy).

I would like to be able to use these numbers to calculate an average at the bottom of the document. But I'm not sure how to do this... I know Excel is great for this, but I don't want to move this whole doc to a spreadsheet for this, since the bulk of this is formatted text.

So my solution was to insert a one celled excel spreadsheet at the end of each paragraph, and then create and insert another single celled spreadsheet at the bottom for the 'average calcutation'. But in this bottom spreadsheet, I dont know how I can reference the other spreadsheets at the end of each paragraph so I can use their values for the calculation.

Is there a way to do this?

TIA

Cerpika