simply use the control key and select the tabs desired to select those
sheetsnow enter what you want in one and it will be the same in the
othersselect one tab to undo the multiple selection.

--
Don Guillett
SalesAid Software

"Chris" wrote in message
...
I have two worksheets contained in the same workbook that
I would like to behave as a single cell value. For
instance, if a value is input into cell A1 on Sheet 1, I
would like it to automatically be entered into cell A1 on
Sheet 2, and vice versa. This can be accomplished with a
handful of if-then statements but is there a more elegant
solution such as cell naming?

Thanks.