Last updated Macro.

[michaelhill94]

I would like to have a macro which displays in one spreadsheet when sections of other worksheets were updated. So for example in sheet A in cell B4 I would like it display when any cells in between A3:10 and C3:10 in sheet C were last changed, in Sheet A cell B5 I would like it to display when any cell in between E3:10 and F3:10 A 12. I really don't know what I'm doing so any help would be greatly appreciated!

 

[BrianB]

Here is something you can adapt. Goes into the code module of the worksheet (right click tab & View Code.

'========================================================
'- LOG WORKSHEET CHANGES
'- puts date into appropriate cell of worksheet "ChangeLog"
'- Ignores cells with "x" in the Log Sheet
'- Brian Baulsom August 2013
'========================================================
Private Sub Worksheet_Change(ByVal Target As Range)
    Dim CellRef As String
    Dim LogSheet As Worksheet
    Set LogSheet = Worksheets("ChangeLog")
    CellRef = ActiveCell.Address
    '----------------------------------------------------
    '- Date to Log
    With LogSheet.Range(CellRef)
        If .Value <> "x" Then
            .Value = Date
        End If
    End With
    '-----------------------------------------------------
End Sub