D
Dave
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
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