Hi Kusky

As for as for your code 1

You can not link 2 cell into 1 cell. If you wish to do so you need to
concatenate the 2 cell. In your example if d23 is available I would
use this function =CONCATENATE(B23," ",C23) and then I would use were
needed(any sheet) the following code ='League Table'!D23.

I will look at the following code and will get back to you

Denis


--
jetted
------------------------------------------------------------------------
jetted's Profile: http://www.excelforum.com/member.php...o&userid=17532
View this thread: http://www.excelforum.com/showthread...hreadid=565228