Hi MS forums,



I am hoping a VB wiz in the forum group can help me with my requirements. My teaching team will be using numbers for a new style of marking schema. To save errors in basic sums I wanted to use VBScript to auto generate cals. The preferred work flow for the teachers is to use Word and then transfer the overall dimensions (grades) to Excel.

I can get the code to calculate one table but hoping to see if someone can help me work out how to get multiple sums from multiple tables. In this case, transfer (to pp3) of two assessment dimensions and then an overall sum (pp3) of both, all without integrating Excel etc.

Thanks in advance if you can help, Brendan

Attached Files

CALCULATOR.docm (49.9 KB, 15 views)