Hi careyc

Lets assume the cell you want to link from is A1 on Sheet1, to cell A1
Sheet2

In cell A1 sheet2 use the following Formula:

=IF(Sheet1!A1="","",Sheet1!A1)


--
Paul Sheppard
------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=394020