Recurring table entries

T

Tom T

Hi all,

I create reports that have several tables in them. One of them recurs
with the same data from 15 to about 50 times (depends on the numbers
of speakers I am reporting on) I usually cut and paste the common data
to each table. Does anyone know how I might speed this process up? Any
suggestions would be appreciated.

TomT
 
G

Greg Maxey

Tom

An entire table can be bookmarked and the bookmark used as a reference.
Select the entire table, assign it a bookmark name, then use that name in a
reference field at other locations you need the table to appear.

{ REF "BookmarkName" }
 
J

Jay Freedman

Hi all,

I create reports that have several tables in them. One of them recurs
with the same data from 15 to about 50 times (depends on the numbers
of speakers I am reporting on) I usually cut and paste the common data
to each table. Does anyone know how I might speed this process up? Any
suggestions would be appreciated.

TomT

One way is to bookmark the first occurrence, and insert cross-references in the
other places to repeat the contents of the bookmark. When you change the
contents of the bookmark, select the whole document (Ctrl+A) and update the
fields (F9). This has a couple of drawbacks. One is that each cell of the first
table has to be bookmarked individually, and each cell of the other tables has
to have a separate cross-reference to its source bookmark; otherwise the
cross-references will insert nested tables within the table cells of the
destination. Another is that bookmarks are easy to delete by accident while
you're editing the source.

Another possibility is to save the source cells as AutoText entries, and place
AUTOTEXT fields in the other tables. This is a little more work to set up, but
is more stable because the AutoText entries can't be changed accidentally. The
main drawback is that AutoText entries must be stored in a template, not in a
document. Also, you can't edit an entry; if it needs to be changed, you insert
it into a document, edit there, and then "add" the entry with the same name to
overwrite the previous version.
 
N

Ned23

You might also be able to use the "Mail Merge" fuction to do this. To do
this you would create a table with the repeating values in it as if it were a
list of addresses and then just paste the merge fields into the document.
When you change the original table, all of the fields in the document will
change.
 
T

Tom T

You might also be able to use the "Mail Merge" fuction to do this.     To do
this you would create a table with the repeating values in it as if it were a
list of addresses and then just paste the merge fields into the document. 
When you change the original table, all of the fields in the document will
change.

Thank you for these great suggestions. I will try them out and report
back my results.
 

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