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
  #1  
Old March 25th, 2009, 06:35 PM posted to microsoft.public.word.pagelayout
Formula in Report
external usenet poster
 
Posts: 13
Default Copy cell from 1 table to another table automatically

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
  #2  
Old March 25th, 2009, 09:23 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,

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


  #3  
Old March 26th, 2009, 12:35 PM posted to microsoft.public.word.pagelayout
Formula in Report
external usenet poster
 
Posts: 13
Default Copy cell from 1 table to another table automatically

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



  #4  
Old March 26th, 2009, 01:26 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

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

"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





  #5  
Old March 26th, 2009, 01:31 PM posted to microsoft.public.word.pagelayout
DeanH
external usenet poster
 
Posts: 1,783
Default Copy cell from 1 table to another table automatically

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



  #6  
Old March 26th, 2009, 01:33 PM posted to microsoft.public.word.pagelayout
DeanH
external usenet poster
 
Posts: 1,783
Default Copy cell from 1 table to another table automatically

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


  #7  
Old March 26th, 2009, 03:21 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

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




  #8  
Old March 26th, 2009, 03:46 PM posted to microsoft.public.word.pagelayout
DeanH
external usenet poster
 
Posts: 1,783
Default Copy cell from 1 table to another table automatically

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





  #9  
Old March 26th, 2009, 04:05 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

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







  #10  
Old March 26th, 2009, 07:18 PM posted to microsoft.public.word.pagelayout
Rich57
external usenet poster
 
Posts: 22
Default Copy cell from 1 table to another table automatically

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








 




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 11:13 AM.


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