Can I type in one cell and have it duplicated in another without .

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I made a purchase order template in word and I have two spaces where the PO#
will appear, one at top and the other at the bottom. Is it possible to key
the number in at the top cell and have it automaticly appear in the bottom
cell?
 
If this is a protected form, the form field is bookmarked and can be
cross-referenced. See http://gregmaxey.mvps.org/Repeating_Data.htm

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
 
Even if it's not a protected form, the original item(s) can be bookmarked,
then replicated elsewhere using a ref field.

Suppose I have #43555667788 inserted in one particular place, and want it to
also appear elsewhere. Select the whole number and choose Insert - Bookmark.
Give it a name and click Add.

Next, put the insertion point where you want the number to appear. Choose
Insert - Field. Under Field Names, choose Ref. Under Bookmark Name:, click
the name you used, then click OK.
 
:hhghg
Even if it's not a protected form, the original item(s) can be bookmarked,
then replicated elsewhere using a ref field.

Suppose I have #43555667788 inserted in one particular place, and want it to
also appear elsewhere. Select the whole number and choose Insert - Bookmark.
Give it a name and click Add.

Next, put the insertion point where you want the number to appear. Choose
Insert - Field. Under Field Names, choose Ref. Under Bookmark Name:, click
the name you used, then click OK.
Click to expand...
Thanks but I was trying to have the number repeat itself in another cell as
I typed it once.
 
If you set the template up correctly, you can have the number appear in
another cell, but only after updating the field. Or, if it's in a protected
form, you could have a macro automatically update the field for you after
finishing the entry. But, if you want the number to appear elsewhere AS
you're typing it, that's not a capability that's built into Word. It likely
could be done using VBA, but it sounds like a lot of work for something
that's not functionally essential.

I'm not aware of ANY _word processors_ that do that... and I believe I've
used them all. Happy hunting!
 
In a protected form, if the field is marked to "calculate on exit" it will
automatically update a REF field that depends on it (as well as calculation
fields).
--

Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

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

See also the MVP FAQ: 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.
 
Back
Top