Home |
Search |
Today's Posts |
#1
|
|||
|
|||
automatically calculate row above in table word 2000
I have a table using =sum(above) and have even tried =sum(b2:b11) to
automatically update the values. I have to lock and protect this form and therefore do not have the option of Autosum, or F9. I need to have this cell update itself as it is entered in the table. I need to have this done in a couple hours. I'm hopeful someone reads this soon and can help me!! thanks! in my email address make sure you 'removethis' from my address - real address is |
#2
|
|||
|
|||
Sorry I wasn't around. You need to double-click the data entry fields and
choose "calculate on exit". **************** Anne Troy www.piersontech.com www.mrexcel.com "~KO" wrote in message ... I have a table using =sum(above) and have even tried =sum(b2:b11) to automatically update the values. I have to lock and protect this form and therefore do not have the option of Autosum, or F9. I need to have this cell update itself as it is entered in the table. I need to have this done in a couple hours. I'm hopeful someone reads this soon and can help me!! thanks! in my email address make sure you 'removethis' from my address - real address is |
#3
|
|||
|
|||
This assumes that the table contains form fields, which is not apparent from
the original post. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Anne Troy" wrote in message ... Sorry I wasn't around. You need to double-click the data entry fields and choose "calculate on exit". **************** Anne Troy www.piersontech.com www.mrexcel.com "~KO" wrote in message ... I have a table using =sum(above) and have even tried =sum(b2:b11) to automatically update the values. I have to lock and protect this form and therefore do not have the option of Autosum, or F9. I need to have this cell update itself as it is entered in the table. I need to have this done in a couple hours. I'm hopeful someone reads this soon and can help me!! thanks! in my email address make sure you 'removethis' from my address - real address is |
#4
|
|||
|
|||
As you're talking about protecting your document I presume you've got form
fields in your table cells which you want people to fill in and then add up. The easiest way to do this successfully is to use a simple macro. Go to Tools - Macros and create a macro called 'update' (or whatever you like). Type the following under the macro procedu Sub update() ActiveDocument.FormFields("Total").Result = Val(ActiveDocument.FormFields("Num1").Result) + Val(ActiveDocument.FormFields("Num2").Result) + Val(ActiveDocument.FormFields("Num3").Result) End Sub (My input boxes have bookmarks called Num1, Num2 and Num3 and the result form field has the bookmark Total). Save your macro and return to your form, set the 'On exit' box for every input box (Num1, Num2, Num3) and the result box (Total) to run the macro 'update' (which should be available from the drop-down list if you've created it successfully). Protect your form, enter some values and you should get the right answer! Andrea Jones "~KO" wrote: I have a table using =sum(above) and have even tried =sum(b2:b11) to automatically update the values. I have to lock and protect this form and therefore do not have the option of Autosum, or F9. I need to have this cell update itself as it is entered in the table. I need to have this done in a couple hours. I'm hopeful someone reads this soon and can help me!! thanks! in my email address make sure you 'removethis' from my address - real address is |
#5
|
|||
|
|||
Whoops! Missed the reference to protecting the form!
-- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Suzanne S. Barnhill" wrote in message ... This assumes that the table contains form fields, which is not apparent from the original post. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Anne Troy" wrote in message ... Sorry I wasn't around. You need to double-click the data entry fields and choose "calculate on exit". **************** Anne Troy www.piersontech.com www.mrexcel.com "~KO" wrote in message ... I have a table using =sum(above) and have even tried =sum(b2:b11) to automatically update the values. I have to lock and protect this form and therefore do not have the option of Autosum, or F9. I need to have this cell update itself as it is entered in the table. I need to have this done in a couple hours. I'm hopeful someone reads this soon and can help me!! thanks! in my email address make sure you 'removethis' from my address - real address is |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert Word 2003 documents to WordPerfect formate | Microsoft Word Help | |||
how to convert wordperfect 5.0 floppy files to word | Microsoft Word Help | |||
WP Delay Code - Word Equiv | Microsoft Word Help | |||
How to change merge forms from Word Perfect to Microsoft Word | Microsoft Word Help | |||
How do I convert a cd in word perfect to microsoft word | Microsoft Word Help |