I have created a form, whereby the user completes sections with grades, data
that is then directed to autopopulate a sheet at the end. I've set this up
using ref codes and bookmarking the source locations.

It all works fine, except that, being as this is an office, the
autopopulation will not work except when the document is printed (or forced
by selecting the whole document and pressing F9). Problem is the people who
fill it out repeatedly DELETE the WHOLE document, rather than saving it.

Is there any way that i can set the document to truely autopopulate, or be
safely forced to do so - apparenrly pressing Ctrl+A followed by F9 is too
damn complicated... any help greatly received