Thanks for all your help, everyone. I have been away for a bit of a long weekend, but I shall start putting your suggestions to work first thing tomorrow... I'm afraid my poor colleague may be a bit overwhelmed by the end of the week!
I'll let you know how we get on with it.