You could do it with a link =sheet2!a2 or a worksheet_change event macro.

--
Don Guillett
SalesAid Software

"Alan" wrote in message
...
I would like to be able to enter data on sheet 1, and also into another
cell
on a different sheet with a different layout at the same time. Is this
possible? I am not too good on excel so step by step guide for idiots
would
be appreciated.