If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
MS Word 2003 - Tables
I have 6 tables containing different cells and all are on
one form page. One cell in each table to the right of the form page is entitled Value and this respresents currency. At the botton of the page, I have one cell entitled "Total Loss This Page". Each of the 6 cells in each of the 6 tables are defined as table1 - table 6. What I want to do is have each of the 6 cells added and this total placed in the cell at the bottom of the page. Currently, the only way I can get this to work is after inputting any data in any of the 6 cells is to place the cursor on the cell entitled "Total Loss This Page", right click and from the drop down menu, click on Update field. After doing so, the cells are added and the total is placed in the approporiate cell. The current formula I use is: =sum(table1,table2,table3,table 4,table 5,table 6). I would like to have this done automatically without clicking and updating. If a dollar amount is only placed in table1 as an example, then that total would show up in the bottom cell. Any amount shown in table2 would be added to table1 and this total would be shown in the bottom cell. Any assistance would be greatly appreciated. I would like to keep it as simple as possible. The form will be password protected prior to allowing others to use it. Thank you. Dave |
#2
|
|||
|
|||
MS Word 2003 - Tables
If you can put up with the document being protected so that formfields will
work, you could do it that way. See: "Please Fill Out This Form" Part 1: Create professional looking forms in Word http://www.computorcompanion.com/LPMArticle.asp?ID=22 Part 2: Adding Automation to your Word forms. http://www.computorcompanion.com/LPMArticle.asp?ID=46 Part 3: Learn more VBA (macros) to automate your forms. http://www.computorcompanion.com/LPMArticle.asp?ID=119 Part 4: Use custom dialog boxes in your Word forms http://www.computorcompanion.com/LPMArticle.asp?ID=127 Part 5: Connect your AutoForm to a database to save input time and keep better records! http://www.computorcompanion.com/LPMArticle.asp?ID=136 -- Please post any further questions or followup to the newsgroups for the benefit of others who may be interested. Unsolicited questions forwarded directly to me will only be answered on a paid consulting basis. Hope this helps Doug Robbins - Word MVP "Dave" wrote in message ... I have 6 tables containing different cells and all are on one form page. One cell in each table to the right of the form page is entitled Value and this respresents currency. At the botton of the page, I have one cell entitled "Total Loss This Page". Each of the 6 cells in each of the 6 tables are defined as table1 - table 6. What I want to do is have each of the 6 cells added and this total placed in the cell at the bottom of the page. Currently, the only way I can get this to work is after inputting any data in any of the 6 cells is to place the cursor on the cell entitled "Total Loss This Page", right click and from the drop down menu, click on Update field. After doing so, the cells are added and the total is placed in the approporiate cell. The current formula I use is: =sum(table1,table2,table3,table 4,table 5,table 6). I would like to have this done automatically without clicking and updating. If a dollar amount is only placed in table1 as an example, then that total would show up in the bottom cell. Any amount shown in table2 would be added to table1 and this total would be shown in the bottom cell. Any assistance would be greatly appreciated. I would like to keep it as simple as possible. The form will be password protected prior to allowing others to use it. Thank you. Dave |
Thread Tools | |
Display Modes | |
|
|