Thanks for the suggestions folks.
Much appreciated.

A macro looks the only way forward as it's a template I'm creating and I'll
want to limit my input and data manipulation to as little as possible.

I was really hoping someone would suggest a function that I'd missed and
that it would be an easy solution.
:-(

Thanks again
:-)