Can data entered in Excel cell simultaneously appear in Word doc?

[Guest]

Hi,

I have Excel 2003 and Word 2003.

Is there a way to have data I enter in a specific cell in Excel
automatically and simultaneously transfer to a specific field in a Word
document?

I'll be creating Excel files that provide details about our company's
clients. Some of this data I want to automatically also appear in a service
agreement in Word. For example, I might want an hourly rate entered on
Sheet 3 in Excel, cell B4, to also appear at a specific point in a Word
document.

Is this possible? If so, how would I do it?

I sincerely appreciate any help you can give me!

 

[Guest]

You can link in either direction:

http://groups.google.com/group/micr...pdate+Excel+from+Word&rnum=1#718bd646a310c68d

 

[Guest]

Gary's Student,

Thank you so much for taking the time to reply!

But is there a way for data to automatically transfer from an Excel cell to
a designated place in a Word document? i.e., without cut and paste?

My client said she went to a recent seminar where the moderator said this is
possible.

Is it?

I appreciate your help.

 

[Guest]

As far as I know, the transfer of data would require either a linking formula
for VBA to copy/paste.