I have had occasion to use embedded worksheets in Word documents. The
problem is that Word treats each worksheet as an individual. How can I take
information from one sheet and bring it into another, i.e. if sheet1 has
information in A1 that I want in sheet2, how can I access, from sheet2, the
information in sheet1!A1?

On Jan 1, 7:22 am, uatuma wrote:
I have had occasion to use embedded worksheets in Word documents. The
problem is that Word treats each worksheet as an individual. How can I take
information from one sheet and bring it into another, i.e. if sheet1 has
information in A1 that I want in sheet2, how can I access, from sheet2, the
information in sheet1!A1?

When I Insert|Object...Microsoft Excel Worksheet then right click the
sheet tab then Insert another worksheet (Sheet2) the two worksheets
work the same as in Excel so the formula =Sheet1!A1 in any cell on
Sheet2 returns Sheet1's A1 value, as expected.

Have you inserted two separate worksheet objects into the Word
document and expecting to be able to use a worksheet formula to link
the two. If so then it seems as though this can't be done. Maybe the
two worksheet objects should be copies of the same worksheet object
with two worksheets, one showing Sheet1, the other showing Sheet 2.

Ken Johnson

Yes, it is usually at least two separate embedded worksheets. Can I use
scope declarations for variables, then assign the contents of the cell(s) in
question to these variables?

"Ken Johnson" wrote:

On Jan 1, 7:22 am, uatuma wrote:
I have had occasion to use embedded worksheets in Word documents. The
problem is that Word treats each worksheet as an individual. How can I take
information from one sheet and bring it into another, i.e. if sheet1 has
information in A1 that I want in sheet2, how can I access, from sheet2, the
information in sheet1!A1?

When I Insert|Object...Microsoft Excel Worksheet then right click the
sheet tab then Insert another worksheet (Sheet2) the two worksheets
work the same as in Excel so the formula =Sheet1!A1 in any cell on
Sheet2 returns Sheet1's A1 value, as expected.

Have you inserted two separate worksheet objects into the Word
document and expecting to be able to use a worksheet formula to link
the two. If so then it seems as though this can't be done. Maybe the
two worksheet objects should be copies of the same worksheet object
with two worksheets, one showing Sheet1, the other showing Sheet 2.

Ken Johnson