To see what can be done in Word, check out my Microsoft Word Field Maths Tutorial, in the 'Sticky' thread at the top of this forum:
https://www.msofficeforums.com/word/...-tutorial.html

As your worksheet employs a dropdown, something similar could be done via a dropdown formfield or content control; the former requires the use of 'filling in forms' protection, whilst the latter would require a macro.

An alternative would be to embed such a worksheet in the document itself.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]