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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
one cell of a table is copied to another cell in same table
I've created a table the top part are word "fill-in" fields. I want to do
something very simple, but can't figure it out. I want to take the text filled in in cell "D1" and copy the contents to cell "A50". Can anyone help? |
#2
|
|||
|
|||
one cell of a table is copied to another cell in same table
On Sun, 22 Jan 2006 12:10:02 -0800, Gizmo0207
wrote: I've created a table the top part are word "fill-in" fields. I want to do something very simple, but can't figure it out. I want to take the text filled in in cell "D1" and copy the contents to cell "A50". Can anyone help? For starters, is the field in cell D1 really a Fill-In field, or is it a text form field? That is, if you press Alt+F9 to display field codes, do you see FILLIN or FORMTEXT in the code in D1? It makes a difference... If it's a Fill-In field, you need to insert a bookmark that "names" the field. Select the field, go to Insert Bookmark, and enter a name (for now I'll assume it's D1, but you should use a name that reflects what the value means). Then go to cell A50 and insert a REF field containing the name of the bookmark in D1. When you update both fields, the Fill-In field displays its dialog box, and the result is displayed in both places. (But updating only the Fill-In field does NOT automatically update the REF field. You need to update both, either by selecting the whole table or document and pressing F9, or by printing/print previewing.) If D1 contains a form field in a protected document, first open the Properties dialog of the form field. Set the Bookmark box to the name you want to use, and check the "Calculate on exit" box. Then insert a REF field in A50 containing the name of the form field in D1. Protect the document. When you change the value in the form field and tab or click to the next form field, the REF field will update automatically. See http://gregmaxey.mvps.org/Repeating_Data.htm for more ways. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Need to Improve Code Copying/Pasting Between Workbooks | David | General Discussion | 1 | January 6th, 2006 03:56 AM |
Table Design | A. Williams | Database Design | 3 | April 29th, 2005 07:02 PM |
unable to repair inobox | Sudheer Mumbai | General Discussion | 1 | February 20th, 2005 11:55 AM |
Manual line break spaces on TOC or Table of tables | Eric | Page Layout | 9 | October 29th, 2004 04:42 PM |
IF E3 & E10 = TRUE set this cell to "Yes", else set to "No" | Timothy L | Worksheet Functions | 5 | August 27th, 2004 02:28 AM |