locked
Auto Populate VBA RRS feed

  • Question

  • I'm creating a form in Word 2010. I have a table set up to Auto sum several fields into a overall score field. What I need to do is this, I need to then have the auto sum field, populate out to various fields throughout the form.

    I've done some searching on the forums, and it looks like I need to create a macro to pull the selected fields into the various areas of the form. I'm not looking for someone to write me the script, just point me in the right direction to name the original auto sum field as well as create the macro.

    Tuesday, December 10, 2013 7:37 PM

Answers

  • All you need do is to bookmark the table, then reference whichever cell holds the value of interest, via a formula field coded as:
    {=SUM(Table1 A1)}
    where 'Table1' is the bookmark name and 'A1' is the cell you want to reference. If the number of rows varies and all you want is the value of the last cell, being one that sums all the cells above, use:
    {=SUM(Table1 A:A)/2}


    Cheers
    Paul Edstein
    [MS MVP - Word]

    • Marked as answer by JgarzaCoffey Thursday, December 12, 2013 9:27 PM
    Tuesday, December 10, 2013 10:54 PM

All replies