A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Page Layout
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Copy cell from 1 table to another table automatically



 
 
Thread Tools Display Modes
  #11  
Old March 26th, 2009, 09:50 PM posted to microsoft.public.word.pagelayout
Suzanne S. Barnhill
external usenet poster
 
Posts: 31,786
Default Copy cell from 1 table to another table automatically

I don't believe you would be able to create a custom property named Title
because there is a built-in Title property (which could just as easily be
used), but the principle is sound. You could also include a UserForm to
collect the data and write it to the property.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"Rich57" wrote in message
...
I think Suzanne's suggestion to use the Document Property called Title is
an
excellent one. In case you are unfamiliar with Document Properties, go to
File, Properties, Custom tab. Type "Title" into the Name box and the
actual
title into the Value box (e.g. "Procedure1"). Click OK.
Now, in your document, you can insert a field that refers to the Title
property anywhere you like, as often as you like.
So, to keep things consistent, open the header where the procedure title
appears first, and replace the text with a field - Insert, Field. Set
Categories to Document Information (the dialog will remember this etting
next
time). Select DocProperty in the Field Names list, and the corresponding
list
of properties appears in the scrollable Property window. Find the Title
property and select it. Click OK.
Now go to the cell in the second table where the procedure is named, and
do
the same - Insert, Field, DocProperty, Title, OK.
Just to make sure that it's working properly, go back to the Document
Properties and change the value of the Title property. Return to the
document, select everything (Ctrl+A) and update fields (F9). Both
locations
should update to the new Title.
Why not save a cut-down version of this document as a template for future
procedures?
--
Richard

Search the web and raise money for charity at http://www.everyclick.com/


"Suzanne S. Barnhill" wrote:

My interpretation was that the OP was bookmarking the cell: "On page one,
I
highlighted the 'Title' cell, clicked on Insert bookmark and named it
'Title'."

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"DeanH" wrote in message
...
I am hoping that the OP is bookmarking only the text, not the whole
cell,
etc.
I only ever had the need to bookmark text, not cells.
Phew ;-)
All the best.
DeanH

"Suzanne S. Barnhill" wrote:

What I found was that, if the entire cell is bookmarked, then the
cross-reference is in the form of a table cell. If only the text is
bookmarked, then any change in the bookmarked text overwrites the
bookmark,
and you get a "not found" error message for the REF field.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"DeanH" wrote in message
...
That is to say Cross-reference the Bookmark.

"DeanH" wrote:

Rest easy, you are not doing anything wrong, only that Word does
not
seem
to
like the creation of cross-references within Table cells.
Try this, create the cross-reference outside the table, then
drag/drop
it
into the cell you want, should work now.
Hope this helps.
DeanH

"Formula in Report" wrote:

Thank you for responding. I am not doing something right. Let
me
try
to
explain what I did and maybe you can spot my problem. Page 1 is
a
procedure
header that is made up using a Table (5 rows and six columns).
One
of
the
middle cells is the TITLE cell. This is the one I want to copy
to
the
following pages actual "headers" made up of 3 rows and 5 columns.
On
page
one, I highlighted the "Title" cell, clicked on Insert bookmark

and
named
it "Title". Then I went to page 2 header, highlighted the title
cell,
clicked on Insert Reference Cross reference. Ref type =
Bookmark;
Insert
Ref = Bookmark text, for which bookmark = "Title" and then cliked
on
insert.
But this did not work; did not copy the page 1 title to page 2.
Can
you tell
what I did wrong?
Thank you again for your help - aurora

"macropod" wrote:

Hi,

You could put the table header into the page header.
Alternatively,
you can bookmark the header entry, then insert a
cross-reference
to the bookmark in the next table's header.

--
Cheers
macropod
[MVP - Microsoft Word]


"Formula in Report"
wrote
in message
...
I am using Word 2003.

I have a document that has a table as a header on the first
page
of
a
procedure. One of the cells contains the name of the
procedure.
The 2nd
page (and beyond) contains another similar table, without as
much
information
as the table on the first page. But the 2nd table also
contains
the name of
the procedure. I want to put a code in the 2nd table that
will
automaticlly
copy the name of the procedure from the first table. I know
I
figured out
how to do this years ago, but can't remember how to do this
now.
Can anyone
help me? This would save me a lot of time if I can remember
how
to
do this.

Thank you - Aurora










  #12  
Old March 26th, 2009, 10:48 PM posted to microsoft.public.word.pagelayout
macropod[_2_]
external usenet poster
 
Posts: 2,402
Default Copy cell from 1 table to another table automatically

Hi Aurora,

If you bookmark the whole source cell, your cross-reference will insert the complete cell (including borders) and a an empty
paragraph before it into the destination cell. If your destination cell is formatted with a set height, you might not, therefore,
see the cross-referenced data.

What you need for this to work is to bookmark only the text in the source cell.

--
Cheers
macropod
[MVP - Microsoft Word]


"Formula in Report" wrote in message
...
Thank you for responding. I am not doing something right. Let me try to
explain what I did and maybe you can spot my problem. Page 1 is a procedure
header that is made up using a Table (5 rows and six columns). One of the
middle cells is the TITLE cell. This is the one I want to copy to the
following pages actual "headers" made up of 3 rows and 5 columns. On page
one, I highlighted the "Title" cell, clicked on Insert bookmark and named
it "Title". Then I went to page 2 header, highlighted the title cell,
clicked on Insert Reference Cross reference. Ref type = Bookmark; Insert
Ref = Bookmark text, for which bookmark = "Title" and then cliked on insert.
But this did not work; did not copy the page 1 title to page 2. Can you tell
what I did wrong?
Thank you again for your help - aurora

"macropod" wrote:

Hi,

You could put the table header into the page header. Alternatively, you can bookmark the header entry, then insert a
cross-reference
to the bookmark in the next table's header.

--
Cheers
macropod
[MVP - Microsoft Word]


"Formula in Report" wrote in message
...
I am using Word 2003.

I have a document that has a table as a header on the first page of a
procedure. One of the cells contains the name of the procedure. The 2nd
page (and beyond) contains another similar table, without as much information
as the table on the first page. But the 2nd table also contains the name of
the procedure. I want to put a code in the 2nd table that will automaticlly
copy the name of the procedure from the first table. I know I figured out
how to do this years ago, but can't remember how to do this now. Can anyone
help me? This would save me a lot of time if I can remember how to do this.

Thank you - Aurora




 




Thread Tools
Display Modes

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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:28 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.