Hi,
I started the thread in the link below and the ultimate response was that it can only be done with VBA programming. I dont know the first thing but i wondered if someone has come across this before and can point me in the right direction.

http://www.excelforum.com/showthread...95958&posted=1

Thanks
Lee