I have a Word document that has two seperate embedded Excel sheets in it.
How can I get a value from one sheet into the other sheet using VBA? For
arguments sake, let's call them sheet1 and sheet2, and I would like a value
from sheet1!A1 to be automatically entered in sheet2:A1 once the value in
sheet1!:A1 is updated. I have asked this question before, but I really need
an answer.

You might get some help from this site. Not sure how much detail they give
in respect to data transfer between two sheets, but they discuss the basics.

http://www.glencoe.com/ps/computered...?articleId=360

"uatuma" wrote:

I have a Word document that has two seperate embedded Excel sheets in it.
How can I get a value from one sheet into the other sheet using VBA? For
arguments sake, let's call them sheet1 and sheet2, and I would like a value
from sheet1!A1 to be automatically entered in sheet2:A1 once the value in
sheet1!:A1 is updated. I have asked this question before, but I really need
an answer.