Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.tables
Rich the Attorney Rich the Attorney is offline
external usenet poster
 
Posts: 1
Default Challenge: Automatically Calculate a Column of Numbers in a Word T

(BTW, I know I can insert an Excel spreadsheet, but you have to click into
the spreadsheet to enter numbers, which, of course will automatically
calculate using the SUM function - too much hassle. I also know I simply can
create any form in Excel and use the Excel program directly instead of Word,
but my fellow office personnel do not know how to use Excel.)

So, what I want to do, believe it or not, is: Use a regular Word table and
be able to enter numbers in a column within that table, and have the table
automatically calculate the total without having to click over the Word table
formula and enter F9 each time (too much of a pain).

I thought I was an expert on using Word tables. I have been using Word,
Excel, and PowerPoint for twenty years, and I thought it couldnt be done.
Until I saw this Word template online:

Go to:
http://www.courts.state.co.us/Self_H...rm_Type_ID/108

Choose the Word Template: JDF 1111 (Sworn Financial Statement)

Go to the bottom of Page 1, and enter a number in the Monthly Deductions
(Mandatory and Voluntary) Table and watch the number in the TOTAL MONTHLY
DEDUCTIONS box change with each number you enter!

Now, the template is locked, so I cant figure out how it was done: Maybe
with macros? As you can see, the table is an actual Word table and not an
imbedded mini Excel spreadsheet, so a Word table can and will automatically
calculate the numbers therein.

This is a doozy - is there anyone out there who can figure this out?

Thanks!
 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Word Table-Automatically show a $ in the money column? Charitychic Tables 6 April 5th 21 04:45 AM
Can word calculate a column in a table in a form template? Bettina Microsoft Word Help 11 July 5th 07 04:00 PM
automatically calculate row above in table word 2000 ~KO Tables 4 March 18th 05 04:13 PM
How do I automatically calculate Word Tables? atomiton Tables 1 February 23rd 05 12:29 AM
How do I calculate page numbers ina 2 column document Liz S Page Layout 2 February 10th 05 01:49 PM


All times are GMT +1. The time now is 02:02 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"