Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-03-2011, 12:33 AM
HalinQuincy HalinQuincy is offline cell of one table to display in a second table Windows 7 64bit cell of one table to display in a second table Office 2003
Novice
cell of one table to display in a second table
 
Join Date: Apr 2011
Location: in the mountain
Posts: 3
HalinQuincy is on a distinguished road
Question 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
Reply With Quote
  #2  
Old 04-03-2011, 09:26 AM
Kimberly Kimberly is offline cell of one table to display in a second table Windows 7 64bit cell of one table to display in a second table Office 2010 64bit
Expert
 
Join Date: May 2010
Posts: 517
Kimberly is on a distinguished road
Default

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.
Reply With Quote
  #3  
Old 04-03-2011, 02:42 PM
HalinQuincy HalinQuincy is offline cell of one table to display in a second table Windows 7 64bit cell of one table to display in a second table Office 2003
Novice
cell of one table to display in a second table
 
Join Date: Apr 2011
Location: in the mountain
Posts: 3
HalinQuincy is on a distinguished road
Default

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
Reply With Quote
  #4  
Old 04-03-2011, 03:43 PM
HalinQuincy HalinQuincy is offline cell of one table to display in a second table Windows 7 64bit cell of one table to display in a second table Office 2003
Novice
cell of one table to display in a second table
 
Join Date: Apr 2011
Location: in the mountain
Posts: 3
HalinQuincy is on a distinguished road
Default 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
Reply With Quote
  #5  
Old 04-03-2011, 04:11 PM
macropod's Avatar
macropod macropod is offline cell of one table to display in a second table Windows 7 32bit cell of one table to display in a second table Office 2000
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
Reply

Thread Tools
Display Modes


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
cell of one table to display in a second table 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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:44 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft