Copy cell from 1 table to another table automatically

[Formula in Report]

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

 

[macropod]

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.

 

[Formula in Report]

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

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]

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

 

[Suzanne S. Barnhill]

When I do this, I get the entire table cell inserted (nested) in the cell in
the second header. How do you avoid this? And if you've managed to get
around that problem, are you using F9 to update the REF field (they don't
update automatically).

Unfortunately, a StyleRef field won't work here. Can you use a DocProperty
field instead? You'd need to create a custom document property (or use the
built-in Title property). Write the appropriate text to that property and
use a DocProperty field for the custom document property or a Title field if
you use that property.

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

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

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]


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

 

[DeanH]

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

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

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]

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

 

[DeanH]

That is to say Cross-reference the Bookmark.

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

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

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]


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

 

[Suzanne S. Barnhill]

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

That is to say Cross-reference the Bookmark.

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

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

:

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]


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

 

[DeanH]

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

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

That is to say Cross-reference the Bookmark.

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

:

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

:

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]


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

 

[Suzanne S. Barnhill]

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

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

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

That is to say Cross-reference the Bookmark.

:

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

:

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

:

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" <[email protected]>
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

 

[Rich57]

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/

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

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

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

That is to say Cross-reference the Bookmark.

:

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

:

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

:

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" <[email protected]>
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

 

[Suzanne S. Barnhill]

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

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/

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

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

:

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

That is to say Cross-reference the Bookmark.

:

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

:

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

:

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" <[email protected]>
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

 

[macropod]

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]

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

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]

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