Automatically updating date when spreadsheet updated?

[Joopers75]

I'm working on a spreadsheet that has a cell for "Last Updated" (B5) - How can I get this to automatically update with the date when any of the other cells (C4:BH21) are changed?

I don't want it to update just on opening/saving, only when physical data has changed.

Any help really appreciated, thanks

 

[My Aswer Is This]

Assuming the values in the range change do to a manual entry and not the result of pasting or formula change
Try this:
This is an auto sheet event script
Your Workbook must be Macro enabled
To install this code:
Right-click on the sheet tab
Select View Code from the pop-up context menu
Paste the code in the VBA edit window
Any time you make a manual change to a cell in the range the Value in Range("B5") will be updated to Todays date.

Private Sub Worksheet_Change(ByVal Target As Range)
'Modified 5/31/18 4:18 AM EDT
If Not Intersect(Target, Range("C4:BH21")) Is Nothing Then
If Target.Cells.CountLarge > 1 Or IsEmpty(Target) Then Exit Sub
Range("B5").Value = Date
End If
End Sub

 

[Joopers75]

That worked absolutely perfectly - thanks a million!

 

[My Aswer Is This]

Glad I was able to help you.
Come back here to Mr. Excel next time you need additional assistance.

That worked absolutely perfectly - thanks a million!

 

[My Aswer Is This]

If you wanted exact time and date try this:

Range("B5").Value = Now()