ENTER DATA INTO 2 CELLS AT THE SAME TIME
 

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.

ENTER DATA INTO 2 CELLS AT THE SAME TIME
 

Maybe just reference it
in sheet 1A1 you will enter the value

In Sheet2B4 enter this
=Sheet1!A1

Nopw sheet2B4 will always change when you change SHeet1A1

ENTER DATA INTO 2 CELLS AT THE SAME TIME
 

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.