Update:
I think I'm nearly there but really struggling with the VBA code.
Side note: I haven't done any coding since Hello World over 10 years ago so might be missing something very basic here, and apologies for any crappy formatting!
It seems to me, the issue is that the "total" isn't being...