Date Change Only When New Data Is Entered

[dbrock1968]

I'm sure this has been asked a million times but I am in a time crush and have to figure this out ASAP! This board has been a great help in stumbling my way through Excel so I hope that someone can help me out with this conundrum!

I have a spreadsheet that we use to keep track of quotes from sub-contractors and plans and drawings. All I need is a formula or macro that will make it so that the date (in A5) is updated ONLY when another cell is changed (new data entered). I can't use TODAY() as it will update no matter what. We use Columns A - I and cells 8 - 500. I am a relative newbie to Excel and VB so please make this somewhat easy to understand! I am in a panic so any help would be greatly appreciated!

Dave

 

[VoG]

Try this: right click the sheet tab, select View Code and paste in

Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
Range("A5").Value = Now
Application.EnableEvents = True
End Sub

Press ALT + Q to close the code window. Once you are happy that it works you can change Now to Date if you wish.

 

[dbrock1968]

PERFECT! Thanks a heap. This does exactly what I needed! Thanks again!