Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can I type in one cell and have it duplicated in another without .
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? |
#2
|
|||
|
|||
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" wrote in message ... 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? |
#3
|
|||
|
|||
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" wrote in message ... 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" wrote in message ... 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? |
#4
|
|||
|
|||
"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" wrote in message ... 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" wrote in message ... 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. |
#5
|
|||
|
|||
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" wrote in message ... "Herb Tyson [MVP]" wrote:hhghg Thanks but I was trying to have the number repeat itself in another cell as I typed it once. |
#6
|
|||
|
|||
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]" wrote in message ... 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" wrote in message ... "Herb Tyson [MVP]" wrote:hhghg Thanks but I was trying to have the number repeat itself in another cell as I typed it once. |