#1
|
|||
|
|||
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 ? |
#2
|
||||
|
||||
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] |
#3
|
|||
|
|||
thank you macropod you are a life saver i was looking for it for 3 days ^^
|
|
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 |