CBG05QB, No bother.

As per the suggestion of mohd9876, I simply have a macro as below and do a run macro everytime I wish to save the file. The typical users of the Excel file won't be aware and hence will only successfully save the file when the cells are correctly entered. If you wish to save to a different file, you need to replace .Save with .SaveAs.

-------
Sub SaveCopies()
Application.EnableEvents = False
ActiveWorkbook.Save
Application.EnableEvents = True
End Sub
------

Hope it helps.