duplicating cells in diffrent sheets

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

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