Duplicating cell values in other cells

B

Bill

Is there a way that a large document that contains many tables can have text values change within specified cells throughout the document after a cell's value in the main table is changed? Would I have to use bookmarks or fields or macros, or what?

As an example, if I change cell A1 in table one to be a new employee's name, once I hit enter and move out of that cell, can cell B7 in table 2 and cell C6 in table 5 get changed to reflect the same text that was just entered into Table 1? This seems simple but I can't seem to figure it out.

Thanks in advance for any help.

Bill
 
G

Greg Maxey

Bill,

You might want to look into "User Forms" a primer is
located here:
http://www.mvps.org/word/FAQs/Userforms/CreateAUserForm.htm

If you are using a protected Word form, the material here
may be useful:
http://www.mvps.org/word/FAQs/TblsFldsFms/LinesInForms.htm
and the series of articles by Dian Chapman.

Basically, each Word form field has a bookmark. You can
change the bookmark name to anything you like. For
example you can call the form field that holds the a
customers name as CusName. Format the formfield (double
click it) to Calculate on Exit. If you want the customer
name to appear elsewhere in the document then use a REF
field like { REF CusName }.
 
C

Charles Kenyon

Look in help under "online forms" for one possible solution.
--

Charles Kenyon

Word New User FAQ & Web Directory:
<URL: http://addbalance.com/word/index.htm>

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide)
<URL: http://addbalance.com/usersguide/index.htm>

See also the MVP FAQ: <URL: http://www.mvps.org/word/> which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

Bill said:
Is there a way that a large document that contains many tables can have
text values change within specified cells throughout the document after a
cell's value in the main table is changed? Would I have to use bookmarks or
fields or macros, or what?
As an example, if I change cell A1 in table one to be a new employee's
name, once I hit enter and move out of that cell, can cell B7 in table 2 and
cell C6 in table 5 get changed to reflect the same text that was just
entered into Table 1? This seems simple but I can't seem to figure it out.
 
C

Candice Mesk

Copy the one that may change, use Paste Special to paste it as formatted
text but as a link. You'll notice it will be a field. You'll have to update
it manually with F9 while you are in the document, but updating takes place
automatically beore printing and on opening the document.

Maybe this answer is more of what you were looking for?


Bill said:
Is there a way that a large document that contains many tables can have
text values change within specified cells throughout the document after a
cell's value in the main table is changed? Would I have to use bookmarks or
fields or macros, or what?
As an example, if I change cell A1 in table one to be a new employee's
name, once I hit enter and move out of that cell, can cell B7 in table 2 and
cell C6 in table 5 get changed to reflect the same text that was just
entered into Table 1? This seems simple but I can't seem to figure it out.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top