Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Word Tables

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 02-15-2016, 12:02 AM
zilot zilot is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Feb 2016
Posts: 2
zilot is on a distinguished road
Default communication between two tables

hi guys ,
i created two tables in word 2013 the first has some values and i want to display automatically the MAX value in the seconde tab
i learned how to use macro to automatically update all fields using some formulas in the same table.
is there a solution using macro or formula and how ?
Reply With Quote
  #2  
Old 02-15-2016, 12:10 AM
macropod's Avatar
macropod macropod is online now Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,199
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Bookmark the first table (e.g. Tbl1) then use a formula field to return the MAX value. For example, a formula field coded as:
{=MAX(Tbl1 C:C)}
will return the maximum value in column C of the table bookmarked as Tbl1. No macros required.

If the values in the first table are being inserted via formfields, checking their 'calculate on exit' property will cause the MAX formula to update every time one of the formfields updates; otherwise, pressing Ctrl-A, F9 will update all fields in the document and selecting just the result returned by the max formula and pressing F9 will update that. Checking Word's 'update fields before printing' option will also ensure the calculation updates at print time.

Note: The field brace pairs (i.e. '{ }') for the above example are all created in the document itself, via Ctrl-F9 (Cmd-F9 on a Mac); you can't simply type them or copy & paste them from this message.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 02-15-2016, 05:49 AM
zilot zilot is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Feb 2016
Posts: 2
zilot is on a distinguished road
Default

thank you macropod you are a life saver i was looking for it for 3 days ^^
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA for Bluetooth Port communication sswcharlie Excel Programming 0 04-12-2015 03:41 PM
a problem with tables, PLEASE HELP ME :/ mohsen123 Word 4 05-05-2014 03:23 AM
Change OL2007 folders for more efficient Carbonite communication? BudVitoff Outlook 2 10-11-2011 03:25 AM
Tables and VBA spl3001 Word VBA 0 03-25-2010 02:18 PM
contingency tables franky_gbr Excel 0 02-18-2008 01:28 PM


All times are GMT -7. The time now is 07:44 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft