#1
|
|||
|
|||
cell of one table to display in a second table
Hi, Sorry if this has been covered, but I couldn't find an answer. I'm a nwbie here. I'm using Word 2003. I have 2 tables on the same page created in Word '03. In cell E17 of the first table I have the formula "=SUM(ABOVE)". What I want is for that product to appear in Cell B4 of table 2. From what I have been able to glean fron the Help files, this is supposed to be possible with the use of "bookmarks". Even though the Help files clearly refernce that this can be done with cells in 2 Word Tables, the only examples seem to be for Table of Contents (TOC). I really need a clear example and/or instructions so I can get this straight. Mahalo Nui Loa |
#2
|
|||
|
|||
I have no trouble with this in version 2010.
Select the sum. Insert Bookmark; I named it Answer. Go to the other table, click in the desired cell. Insert a cross-reference to the bookmark. |
#3
|
|||
|
|||
Thanks,
Ah, what a difference a word makes. The help file was very confusing. The 2 sticking points I was having were; 1) the contents of the 1st cell need to be highlighted (I gather this is what you meant by "selected") not just have the cursor blinking in the cell. 2) In the cross reference box I expected to see something that refered to the numbers in the cell and not "bookmark.txt" and other completely unapplicable choices. Mahalo Nui Loa, HalinQuincy |
#4
|
|||
|
|||
reference for possible formulas in Word Tables?
I was just wondering if there is a refence that gives examples and syntax for possible formulas in Word Tables. For example I understand "=SUM(b4,b5) gives the sum of the 2 cells by adding the 2. How about if you want to subtract b5 from b4. WHat would that formula look like. or, can it not be done?
Mahalo |
#5
|
||||
|
||||
Hi halhein,
You can reference any numerical value in a table from outside the table by bookmarking the whole table (or even just one of the end-of-row markers), then using a formula field. For example, suppose you bookmark the table as 'Tbl1' and you want to reference the value in cell E17. In that case, you could use a formula field coded as: {=SUM(Tbl1 E17)} (the field braces '{}' are created via Ctrl-F9). To see how to do a wide range of calculations in Word, check out my Microsoft Word Field Maths Tutorial, at: http://windowssecrets.com/forums/sho...Maths-Tutorial or: http://www.gmayor.com/downloads.htm#Third_party
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Control cell width and wrapping in table. | gcowan | Word Tables | 0 | 07-07-2010 11:28 AM |
Table cell border | markg2 | Word Tables | 2 | 01-15-2010 05:22 PM |
Text Wrapping on Fixed Lines in a Form field/Table cell | okrmjr | Word Tables | 0 | 10-30-2009 08:52 AM |
Auto-populate an MS Word table cell with text from a diff cell? | dreamrthts | Word Tables | 0 | 03-20-2009 01:49 PM |
How do I reference a merged cell in a multi column & row table in MS Word ('03')? | jihanemo | Word Tables | 0 | 03-18-2009 08:33 AM |