Put this in Sheet2 cell A10:
=if(sheet1!b6="","",sheet1!b6)



kevatt wrote:

the senareo agian : i wish to enter data in sheet 1 cell b6 and also
display the same information in sheet 2 a10

or

sheet 1 cell a1+b1+c1 anwser to appear in d1 and also a10 on sheet 2

--
kevatt
------------------------------------------------------------------------
kevatt's Profile: http://www.excelforum.com/member.php...o&userid=30245
View this thread: http://www.excelforum.com/showthread...hreadid=501218

--

Dave Peterson