PC Review


Reply
Thread Tools Rate Thread

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

 
 
=?Utf-8?B?ZGF2aWRfZA==?=
Guest
Posts: n/a
 
      22nd Dec 2004
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?
 
Reply With Quote
 
 
 
 
Suzanne S. Barnhill
Guest
Posts: n/a
 
      22nd Dec 2004
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
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"david_d" <(E-Mail Removed)> wrote in message
news:7C4D8FAB-BF13-40E9-A3EE-(E-Mail Removed)...
> 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?


 
Reply With Quote
 
Herb Tyson [MVP]
Guest
Posts: n/a
 
      23rd Dec 2004
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.

--
Herb Tyson MS MVP
Please respond in the newsgroups so everyone can follow along.
http://www.herbtyson.com
"Suzanne S. Barnhill" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
> Word MVP FAQ site: http://word.mvps.org
> Email cannot be acknowledged; please post all follow-ups to the newsgroup
> so
> all may benefit.
>
> "david_d" <(E-Mail Removed)> wrote in message
> news:7C4D8FAB-BF13-40E9-A3EE-(E-Mail Removed)...
>> 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?

>



 
Reply With Quote
 
=?Utf-8?B?ZGF2aWRfZA==?=
Guest
Posts: n/a
 
      23rd Dec 2004
"Herb Tyson [MVP]" wrote: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.
>
> --
> Herb Tyson MS MVP
> Please respond in the newsgroups so everyone can follow along.
> http://www.herbtyson.com
> "Suzanne S. Barnhill" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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
> > Word MVP FAQ site: http://word.mvps.org
> > Email cannot be acknowledged; please post all follow-ups to the newsgroup
> > so
> > all may benefit.
> >
> > "david_d" <(E-Mail Removed)> wrote in message
> > news:7C4D8FAB-BF13-40E9-A3EE-(E-Mail Removed)...
> >> 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?

> >

>
>

Thanks but I was trying to have the number repeat itself in another cell as
I typed it once.
 
Reply With Quote
 
Herb Tyson [MVP]
Guest
Posts: n/a
 
      23rd Dec 2004
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!

--
Herb Tyson MS MVP
Please respond in the newsgroups so everyone can follow along.
http://www.herbtyson.com
"david_d" <(E-Mail Removed)> wrote in message
news:7641C54B-11B7-431C-8E84-(E-Mail Removed)...
> "Herb Tyson [MVP]" wrote:hhghg
>


>>

> Thanks but I was trying to have the number repeat itself in another cell
> as
> I typed it once.



 
Reply With Quote
 
Charles Kenyon
Guest
Posts: n/a
 
      24th Dec 2004
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.

"Herb Tyson [MVP]" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> 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!
>
> --
> Herb Tyson MS MVP
> Please respond in the newsgroups so everyone can follow along.
> http://www.herbtyson.com
> "david_d" <(E-Mail Removed)> wrote in message
> news:7641C54B-11B7-431C-8E84-(E-Mail Removed)...
>> "Herb Tyson [MVP]" wrote:hhghg
>>

>
>>>

>> Thanks but I was trying to have the number repeat itself in another cell
>> as
>> I typed it once.

>
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Duplicated cell =?Utf-8?B?RGF2aWQ=?= Microsoft Excel Misc 4 30th Jan 2007 09:35 AM
can a cell value to be duplicated to another cell during data entr =?Utf-8?B?bWljaGFlbCBN?= Microsoft Excel Worksheet Functions 2 9th Mar 2006 01:08 PM
When copying a cell to another cell the information is duplicated. =?Utf-8?B?c2ljYXA=?= Microsoft Excel Worksheet Functions 0 30th Dec 2005 08:03 PM
duplicated content-type name =?Utf-8?B?emVubw==?= Microsoft Outlook 0 3rd Apr 2004 01:16 AM
Word XP Duplicated Type from one file to another Peter Microsoft Word Document Management 0 9th Jul 2003 11:31 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:09 AM.