What is causing the data to change - manual changes? then you can use the
Change event in Sheet2. Right click on Sheet2 tab and select view code. In
the code module put in code like

Private Sub Worksheet_Change(ByVal Target As Range)
worksheets("Sheet1").Range("A111").Value = "A"
End Sub

If you just want to know if the workbook needs to be saved, looked at the

ThisWorkbook.Saved property.

--
Regasrds,
Tom Ogilvy





"pswanie" wrote:

hey...

what code would i use where to get a "A" in cell a111 on sheet1 when a user
change any cell on sheet2?