Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how to link cells
how to link cells in separate tables, but same document, so that anything
entered in one cell, automatically displays in second cell. |
#2
|
|||
|
|||
Put a bookmark on a cell, then cross-reference it:
http://www.officearticles.com/word/c...oft_word .htm ******************* ~Anne Troy www.OfficeArticles.com "icebreaker" wrote in message ... how to link cells in separate tables, but same document, so that anything entered in one cell, automatically displays in second cell. |
#3
|
|||
|
|||
icebreaker was telling us:
icebreaker nous racontait que : how to link cells in separate tables, but same document, so that anything entered in one cell, automatically displays in second cell. Use {REF} fields where you want the repeated text. E.g: On page one, you have some text; Assign a bookmark to that text (Insert Bookmarks, let's call it "Text1"); Everywhere else you want the text bookmarked by Text1 to appear do: CTRL-F9; A pair of { } will appear; Type REF Text1 between the curly braces; Create all the REF fields you want. When you are done do ALT-F9 twice to switch from field code view to regular view. If you are dealing with protected forms: Again, use {REF} fields where you want the repeated text. E.g: On page one, you have a text field named "Text1" (right click the field, click properties, and see/change the name where it says Bookmark, bottom right corner). Everywhere else you want Text1 to appear do: CTRL-F9; A pair of { } will appear; Type REF Text1 between the curly braces; Create all the REF fields you want; In the field where the text originates, make sure to check the "calculate on exit" checkbox so that all REF fields will be updated automatically when leaving the text fields; Finally, do ALT-F9 twice to turn the REF fields into their values (They will seem to disappear the first time as they will be linked to empty fields); Lock the form; Type some text in Text1; See all the REF Text1 field update when you tab out of Text1. -- Salut! _______________________________________ Jean-Guy Marcil - Word MVP ISTOO Word MVP site: http://www.word.mvps.org |
#4
|
|||
|
|||
On Wed, 13 Jul 2005 17:22:02 -0700, "icebreaker"
wrote: how to link cells in separate tables, but same document, so that anything entered in one cell, automatically displays in second cell. See http://gregmaxey.mvps.org/Repeating_Data.htm -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org |
#5
|
|||
|
|||
Thanks. All these tips helped but I could still use more advice. The
document is a test report with about 100-200 PASS/FAIL tests. In the beginning of the report is a single table to summarize the test results. After the summary table there are the same tests, but in individual verbose tables. For example, if PASS or FAIL is entered in test number 5 of the summary table, I would like the test 5 result to be updated (PASS or FAIL) in the test 5 verbose table. Or if PASS or FAIL is entered in test 5 of the verbose table, I would like the test 5 result to be updated (PASS or FAIL) in the test 5 summary. I actually have three text entries for the results, PASS, PASS* & FAIL*. An asterisk indicates comments about the test are included in the document. Additionally I would like to export my PASS/FAIL test results from the Word Doc to an Excel spreadsheet. Thanks for your help! "Jean-Guy Marcil" wrote: icebreaker was telling us: icebreaker nous racontait que : how to link cells in separate tables, but same document, so that anything entered in one cell, automatically displays in second cell. Use {REF} fields where you want the repeated text. E.g: On page one, you have some text; Assign a bookmark to that text (Insert Bookmarks, let's call it "Text1"); Everywhere else you want the text bookmarked by Text1 to appear do: CTRL-F9; A pair of { } will appear; Type REF Text1 between the curly braces; Create all the REF fields you want. When you are done do ALT-F9 twice to switch from field code view to regular view. If you are dealing with protected forms: Again, use {REF} fields where you want the repeated text. E.g: On page one, you have a text field named "Text1" (right click the field, click properties, and see/change the name where it says Bookmark, bottom right corner). Everywhere else you want Text1 to appear do: CTRL-F9; A pair of { } will appear; Type REF Text1 between the curly braces; Create all the REF fields you want; In the field where the text originates, make sure to check the "calculate on exit" checkbox so that all REF fields will be updated automatically when leaving the text fields; Finally, do ALT-F9 twice to turn the REF fields into their values (They will seem to disappear the first time as they will be linked to empty fields); Lock the form; Type some text in Text1; See all the REF Text1 field update when you tab out of Text1. -- Salut! _______________________________________ Jean-Guy Marcil - Word MVP ISTOO Word MVP site: http://www.word.mvps.org |
#6
|
|||
|
|||
Also, the document form must remain unlocked.
"icebreaker" wrote: Thanks. All these tips helped but I could still use more advice. The document is a test report with about 100-200 PASS/FAIL tests. In the beginning of the report is a single table to summarize the test results. After the summary table there are the same tests, but in individual verbose tables. For example, if PASS or FAIL is entered in test number 5 of the summary table, I would like the test 5 result to be updated (PASS or FAIL) in the test 5 verbose table. Or if PASS or FAIL is entered in test 5 of the verbose table, I would like the test 5 result to be updated (PASS or FAIL) in the test 5 summary. I actually have three text entries for the results, PASS, PASS* & FAIL*. An asterisk indicates comments about the test are included in the document. Additionally I would like to export my PASS/FAIL test results from the Word Doc to an Excel spreadsheet. Thanks for your help! "Jean-Guy Marcil" wrote: icebreaker was telling us: icebreaker nous racontait que : how to link cells in separate tables, but same document, so that anything entered in one cell, automatically displays in second cell. Use {REF} fields where you want the repeated text. E.g: On page one, you have some text; Assign a bookmark to that text (Insert Bookmarks, let's call it "Text1"); Everywhere else you want the text bookmarked by Text1 to appear do: CTRL-F9; A pair of { } will appear; Type REF Text1 between the curly braces; Create all the REF fields you want. When you are done do ALT-F9 twice to switch from field code view to regular view. If you are dealing with protected forms: Again, use {REF} fields where you want the repeated text. E.g: On page one, you have a text field named "Text1" (right click the field, click properties, and see/change the name where it says Bookmark, bottom right corner). Everywhere else you want Text1 to appear do: CTRL-F9; A pair of { } will appear; Type REF Text1 between the curly braces; Create all the REF fields you want; In the field where the text originates, make sure to check the "calculate on exit" checkbox so that all REF fields will be updated automatically when leaving the text fields; Finally, do ALT-F9 twice to turn the REF fields into their values (They will seem to disappear the first time as they will be linked to empty fields); Lock the form; Type some text in Text1; See all the REF Text1 field update when you tab out of Text1. -- Salut! _______________________________________ Jean-Guy Marcil - Word MVP ISTOO Word MVP site: http://www.word.mvps.org |
#7
|
|||
|
|||
icebreaker was telling us:
icebreaker nous racontait que : Thanks. All these tips helped but I could still use more advice. The document is a test report with about 100-200 PASS/FAIL tests. In the beginning of the report is a single table to summarize the test results. After the summary table there are the same tests, but in individual verbose tables. For example, if PASS or FAIL is entered in test number 5 of the summary table, I would like the test 5 result to be updated (PASS or FAIL) in the test 5 verbose table. Or if PASS or FAIL is entered in test 5 of the verbose table, I would like the test 5 result to be updated (PASS or FAIL) in the test 5 summary. You can't have it both ways. One of them has to be the source. Up to you to choose which makes more sense according to your context. I actually have three text entries for the results, PASS, PASS* & FAIL*. An asterisk indicates comments about the test are included in the document. Additionally I would like to export my PASS/FAIL test results from the Word Doc to an Excel spreadsheet. If you set up the summary as a table, it will be easy to export it to Excel as is. -- Salut! _______________________________________ Jean-Guy Marcil - Word MVP ISTOO Word MVP site: http://www.word.mvps.org |
#8
|
|||
|
|||
I have an unprotected document and I choose the verbose tables as the source.
After each test is completed, the PASS, PASS* or FAIL* result is updated in the document for that test. The PASS, PASS* or FAIL* choice remains the same, but each test (100 to 200 tests) must be updated individually. Do you have advice on how to update over 100 summary tests individually with PASS, PASS* or FAIL? This would be easier if I could protect the document. Thanks! "Jean-Guy Marcil" wrote: icebreaker was telling us: icebreaker nous racontait que : Thanks. All these tips helped but I could still use more advice. The document is a test report with about 100-200 PASS/FAIL tests. In the beginning of the report is a single table to summarize the test results. After the summary table there are the same tests, but in individual verbose tables. For example, if PASS or FAIL is entered in test number 5 of the summary table, I would like the test 5 result to be updated (PASS or FAIL) in the test 5 verbose table. Or if PASS or FAIL is entered in test 5 of the verbose table, I would like the test 5 result to be updated (PASS or FAIL) in the test 5 summary. You can't have it both ways. One of them has to be the source. Up to you to choose which makes more sense according to your context. I actually have three text entries for the results, PASS, PASS* & FAIL*. An asterisk indicates comments about the test are included in the document. Additionally I would like to export my PASS/FAIL test results from the Word Doc to an Excel spreadsheet. If you set up the summary as a table, it will be easy to export it to Excel as is. -- Salut! _______________________________________ Jean-Guy Marcil - Word MVP ISTOO Word MVP site: http://www.word.mvps.org |
#9
|
|||
|
|||
Assuming that the summary table has two columns and a heading row, with the
summary results being required in the second column, and that each of the individual tables has two columns and a heading row with the result of the test being entered into the Column 2 of Row 2 of the table, if you run the following macro, it will populate the results column of the summary table with the result of each individual test: Dim i As Long, result As Range For i = 2 To ActiveDocument.Tables(1).Rows.Count Set result = ActiveDocument.Tables(i).Cell(2, 2).Range result.End = result.End - 1 ActiveDocument.Tables(1).Cell(i, 2).Range = result Next i As Jean-Guy has mentioned, with the summary table populated, it can be just a copy and paste to get it into Excel. However, using the information in the article "Control Excel from Word" at: http://word.mvps.org/FAQs/InterDev/C...XLFromWord.htm The above macro could be modified so that it populated and Excel spreadsheet at the same time as it populated the summary table. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "icebreaker" wrote in message ... Thanks. All these tips helped but I could still use more advice. The document is a test report with about 100-200 PASS/FAIL tests. In the beginning of the report is a single table to summarize the test results. After the summary table there are the same tests, but in individual verbose tables. For example, if PASS or FAIL is entered in test number 5 of the summary table, I would like the test 5 result to be updated (PASS or FAIL) in the test 5 verbose table. Or if PASS or FAIL is entered in test 5 of the verbose table, I would like the test 5 result to be updated (PASS or FAIL) in the test 5 summary. I actually have three text entries for the results, PASS, PASS* & FAIL*. An asterisk indicates comments about the test are included in the document. Additionally I would like to export my PASS/FAIL test results from the Word Doc to an Excel spreadsheet. Thanks for your help! "Jean-Guy Marcil" wrote: icebreaker was telling us: icebreaker nous racontait que : how to link cells in separate tables, but same document, so that anything entered in one cell, automatically displays in second cell. Use {REF} fields where you want the repeated text. E.g: On page one, you have some text; Assign a bookmark to that text (Insert Bookmarks, let's call it "Text1"); Everywhere else you want the text bookmarked by Text1 to appear do: CTRL-F9; A pair of { } will appear; Type REF Text1 between the curly braces; Create all the REF fields you want. When you are done do ALT-F9 twice to switch from field code view to regular view. If you are dealing with protected forms: Again, use {REF} fields where you want the repeated text. E.g: On page one, you have a text field named "Text1" (right click the field, click properties, and see/change the name where it says Bookmark, bottom right corner). Everywhere else you want Text1 to appear do: CTRL-F9; A pair of { } will appear; Type REF Text1 between the curly braces; Create all the REF fields you want; In the field where the text originates, make sure to check the "calculate on exit" checkbox so that all REF fields will be updated automatically when leaving the text fields; Finally, do ALT-F9 twice to turn the REF fields into their values (They will seem to disappear the first time as they will be linked to empty fields); Lock the form; Type some text in Text1; See all the REF Text1 field update when you tab out of Text1. -- Salut! _______________________________________ Jean-Guy Marcil - Word MVP ISTOO Word MVP site: http://www.word.mvps.org |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
mail merge with a link | Mailmerge | |||
Link to cells in Excel? | Microsoft Word Help | |||
Link Link Link | Microsoft Word Help | |||
Excel Link: Adding rows in Excel does not add cells in Word | Tables | |||
How do I link cells in a table? | Tables |