Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-15-2016, 12:02 AM
zilot zilot is offline communication between two tables Windows 7 64bit communication between two tables Office 2013
Novice
communication between two tables
 
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 offline communication between two tables Windows 7 64bit communication between two tables Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

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
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 02-15-2016, 05:49 AM
zilot zilot is offline communication between two tables Windows 7 64bit communication between two tables Office 2013
Novice
communication between two tables
 
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
communication between two tables a problem with tables, PLEASE HELP ME :/ mohsen123 Word 4 05-05-2014 03:23 AM
communication between two tables 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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:38 PM.


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