Hi Chris,

Try this if you want the cell values to be on Sheet2.
Enter it on the Sheet1 object in the VBA editor.

Private Sub Worksheet_Change(ByVal Target As Range)
ThisWorkbook.Worksheets("Sheet2"). _
Range(Target.Address).Value = Target.Value
End Sub

OOPs - "and vice versa"
Enter this on the Sheet2 object:
Private Sub Worksheet_Change(ByVal Target As Range)
ThisWorkbook.Worksheets("Sheet1"). _
Range(Target.Address).Value = Target.Value
End Sub

Best Regards,
Walt

-----Original 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.
.