If you open the template Graham posted and press Alt-F11, that will open the VBA Editor. If you then click on the template's 'ThisDocument' Code module, you'll see the code he's used to do all the work. I'd have approached it differently, along the lines of what you'll see in
https://www.msofficeforums.com/word-...html#post46903. There you'll see that the dependent amounts are stored in the value field of each dropdown entry; the code is far simpler that way and gives you a template that's far easier to update as entries are added/deleted and/or the corresponding values change.