If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Automated copying of data throughout a document
I have read the instructions at
http://www.officearticles.com/word/c...oft_word .htm It does not seem to work when the field that I am wanting to bookmark is a calculated field. When I put a calculation into the field the bookmark is gone from the list. Then I tried setting the bookmark before entering the calculation; that worked until I put in the calc. At that point I got a undefined bookmark warning on my destination field. Is there a way to do this? Thanks for any help. ConnieW -- Connie W "Anne Troy" wrote: Use a cross-reference to a bookmark. http://www.officearticles.com/word/c...oft_word .htm ******************* ~Anne Troy www.OfficeArticles.com "Jim West" wrote in message ... If I want to fill in data on one part of a form and have it automatically propogate into other fields in the report, what do I do? -- Jim |
#2
|
|||
|
|||
Automated copying of data throughout a document
The calculation field is going to have a bookmark name. Double click
the field before protecting and you can see what it is then. If you want to repeat the result of this field then use a REF field to the bookmark. Say the field is bookmarked Text5, then: { Text5 } is using Ctrl+F9 to enter the { } is all you need. |
#3
|
|||
|
|||
Automated copying of data throughout a document
this doesn't work. When I double click on the calculated field nothing
happens. Perhaps I am doing the calc incorrectly. What I did was create the field and then use the formula option under the table menu. After I put in the formula the bookmark name disappears. Is there another way? -- Connie W "Greg Maxey" wrote: The calculation field is going to have a bookmark name. Double click the field before protecting and you can see what it is then. If you want to repeat the result of this field then use a REF field to the bookmark. Say the field is bookmarked Text5, then: { Text5 } is using Ctrl+F9 to enter the { } is all you need. |
#4
|
|||
|
|||
Automated copying of data throughout a document
Connie,
Are you using a protected form? Where are the variables coming from in your calculation? Are you using tables cells? Like A1=2 B1=2 C1= {Sum(Left) } ? Then just use { =(C1) } where you want the calculation value repeated in the table. |
#5
|
|||
|
|||
Automated copying of data throughout a document
Greg, the place I want to repeat it is not in the table. Will your techniqe
still work? ConnieW -- Connie W "Greg Maxey" wrote: Connie, Are you using a protected form? Where are the variables coming from in your calculation? Are you using tables cells? Like A1=2 B1=2 C1= {Sum(Left) } ? Then just use { =(C1) } where you want the calculation value repeated in the table. |
#6
|
|||
|
|||
Automated copying of data throughout a document
No. But if you select the result to the calculation and then assign it
a bookmark name (InsertBookmark). Say you assign it the name C1. Then you can just use a REF field { C1 } outside the table. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How Come? | Michael Koerner | Mailmerge | 9 | February 10th, 2006 10:29 PM |
Microsoft Office should use an advance data crosslinking model | m_jurrens | General Discussions | 0 | December 15th, 2005 07:33 AM |
Excel Macro to Copy & Paste | [email protected] | Worksheet Functions | 0 | December 1st, 2005 01:56 PM |
strategy for data entry in multiple tables | LAF | Using Forms | 18 | April 25th, 2005 04:04 AM |
multiple docs, one data source | kp | Mailmerge | 12 | January 31st, 2005 04:41 PM |