To automate the process, you could use a Selection_Change macro, but that's a lot of work to implement. A simpler approach would be to have another formfield, say a checkbox formfield, in the second cell on the last row that, when clicked, triggers the macro. You do that by selecting the macro from the formfield's 'on entry' property. To use the same macro on multiple tables, you could then simply change:
With .Tables(1)
to:
With Selection.Tables(1)


and, if you want to delete the formfield that triggered the macro as well, insert:
Selection.FormFields(1).Delete
before:
.Protect Type:=wdAllowOnlyFormFields, NoReset:=True, Password:=StrPwd

PS: I note you're using a formfield to tally the column-2 values. The problem with this approach is that (a) you're using bookmarks that may get deleted when the referenced rows get deleted; (b) there's nothing in your code to cause the tally to update; and (c) calculation formfields taking input from other formfields are dodgy. To resolve (a) and (c), replace the calculation formfield with a formula field, coded as:{=SUM(ABOVE) \# £0.00 }
For (b), check each of the other formfields' 'calculate on exit' property.

Note: The field brace pairs (i.e. '{ }') for the above example are created in the document itself, via Ctrl-F9 (Cmd-F9 on a Mac); you can't simply type them or copy & paste them from this message.

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

Hi Paul,

Thank you for the additional guidance re: adding values - will amend accordingly.

I'm struggling to understand the multiple tables piece - how will the code know which tables it applies to?

It 'knows' that from the use of 'Selection.Tables(1)'. Since the formfield the macro is attached to is a Selection, that tells Word to use the first table in the selected range, rather than the first table in the document.

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

Hello,

Apologies for the simple/ daft questions; I'm new to this so it's all a very steep learning curve!

I've tried altering the code so that the same happens to table 18 (with the formfield in the 3rd column), I changed the table reference to correspond, but no deletion occurs. There is a Reference field in column 2, but as this is not a formfield I'm thinking that this won't be impacting on it. Is there a bit of the code which needs updating to reflect that it's the 3rd column?