Static Dates within Excel

[Sarlou73]

Hi, I wonder if you can help me?
I want to add a date into cell Q when adding data into cell N but I also want to ensure that that date remains static, so when the spreadsheet is re-opened the historic date remains. Also, I want to add a date to column E which will remain static. I have entered the formula = TODAY() but when I re-open the spreadsheet I lose the historic date. Can you please advise how I can do this?
Many thanks
Sarah

 

[VoG]

Hi. Right click the sheet tab, select View Code and paste in

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 14 Then Target.Offset(, 3).Value = Date
End Sub

 

[Sarlou73]

Hi Thanks for this. I have pasted this into the VB module and it doesn't seem to be working? Can you please advise

 

[VoG]

That has to go into the sheet's module, not a regular module, and macros must be enabled.

 

[Sarlou73]

Hi I am new to this and learning as I go along so you'll have to bear with me. I have saved this spreadsheet as a macro enabled workbook and also the module is within the spreadsheet underneath the microsoft excel objects. If I enter into column N and then run the macro nothing happens!

 

[VoG]

The macro will run automatically but you have to put it it the sheet's code module. Right click the sheet's tab, select View Code then paste the code into the window that appears.

 

[Sarlou73]

Thank you for your help - much appreciated