Can anyone suggest a good way of doing this apart from the obvious manual option.

Cheers