thanx to tom for sending some code but it was a little vague did not
know if ths was code that needed to in in corparated in the giving an
overall format or if the cells need to be coded singular

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


I think this may be one for the experienced

once again step by step pleaze


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