Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Tables / August 2007

Tip: Looking for answers? Try searching our database.

How to link a document field to a table cell?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Chad@KSA - 26 Aug 2007 16:30 GMT
I have a table in a WORD document. Later in the document, I need to extract
data from a particular cell in the table. How do I do that?
Lene Fredborg - 26 Aug 2007 17:36 GMT
See this article:
http://gregmaxey.mvps.org/Repeating_Data.htm

Signature

Regards
Lene Fredborg
DocTools - Denmark
www.thedoctools.com
Document automation - add-ins, macros and templates for Microsoft Word

> I have a table in a WORD document. Later in the document, I need to extract
> data from a particular cell in the table. How do I do that?
Chad@KSA - 26 Aug 2007 18:48 GMT
Thanks, eventually I did find the bookmark&REF function. However I have found
it is easy to loose the bookmarks. Any suggestions for not losing them?

> See this article:
> http://gregmaxey.mvps.org/Repeating_Data.htm
>
> > I have a table in a WORD document. Later in the document, I need to extract
> > data from a particular cell in the table. How do I do that?
Chad@KSA - 26 Aug 2007 18:48 GMT
Thanks. I eventually found the bookmark&REF combination. However, I found it
is easy to lose the bookmarks. Any suggestions of how to protect them?

> See this article:
> http://gregmaxey.mvps.org/Repeating_Data.htm
>
> > I have a table in a WORD document. Later in the document, I need to extract
> > data from a particular cell in the table. How do I do that?
Lene Fredborg - 26 Aug 2007 19:42 GMT
Unless you change your document to a protected form, a bookmark _can_ be
deleted quite easily. But if you are the only person editing the document,
you know about the bookmark and you can be careful not to delete it.

One way to make the bookmark more "safe" could be to select the entire table
cell when adding the bookmark (then the bookmark will not be deleted unless
you delete the cell). However, this means that the reference to the bookmark
will also insert the entire table cell - I don't know whether this is
acceptable. Bookmarking the entire table cell will make sure that the
reference always contains all contents from the table cell. If the bookmark
includes only the text, there is a risk that content is added outside the
bookmark. For details about such bookmark problems, see the demos at:
http://www.thedoctools.com/index.php?show=wt_cross-reference_trouble

For help on forms, see:
http://www.word.mvps.org/FAQs/Customization/FillinTheBlanks.htm

Signature

Regards
Lene Fredborg
DocTools - Denmark
www.thedoctools.com
Document automation - add-ins, macros and templates for Microsoft Word

> Thanks. I eventually found the bookmark&REF combination. However, I found it
> is easy to lose the bookmarks. Any suggestions of how to protect them?
[quoted text clipped - 4 lines]
> > > I have a table in a WORD document. Later in the document, I need to extract
> > > data from a particular cell in the table. How do I do that?
macropod - 27 Aug 2007 11:02 GMT
Hi Chad,

If the cell you want to refer to has only numeric data in it, you can bookmark the entire table, then use a formula to reference the
cell. I think your users would be much less likely to delete such a bookmark - unless they delete the entire table.

As an example, say you select the table and bookmark it as 'MyTable'. You could then reference cell C1 from that table via a formula
field coded as {=SUM(MyTable C1)}. You can use the same technique to replicate data across tables and to perform maths on data in
the tables from outside the tables concerned.

Cheers
Signature

macropod
[MVP - Microsoft Word]
-------------------------

> Thanks. I eventually found the bookmark&REF combination. However, I found it
> is easy to lose the bookmarks. Any suggestions of how to protect them?
[quoted text clipped - 4 lines]
>> > I have a table in a WORD document. Later in the document, I need to extract
>> > data from a particular cell in the table. How do I do that?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.