A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Tables
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

MS Word 2003 - Tables



 
 
Thread Tools Display Modes
  #1  
Old May 12th, 2004, 06:37 PM
Dave
external usenet poster
 
Posts: n/a
Default 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  
Old May 14th, 2004, 07:11 AM
Doug Robbins - Word MVP
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:55 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.