Date Stamp List help

[nashgas]

I have a sheet that needs to have date stamp every time a change is made or at least every time its opened or saved.
I need to keep track of all dates its been changed.

I was hoping to create a column preferably the O column that added the date below the previous every time it was opened or saved.

I only need date so for example;
O1 05/15/2011
O2 07/23/2011
O3 10/17/2011

I greatly appreciate any help anyone can provide for this.

I am using Excel 2010

 

[Trevor G]

Welcome to the forum,

Try this out.

Add a Sheet and name it Log.
In Cell C1 Place in a title like Log Date
Select the Sheet you want to log the date from and then use right mouse button and select View Code
Change the first drop down from Object to Worksheet and the next to Activate

Add in this code.

Private Sub Worksheet_Activate()
Sheets("Log").Range("C" & Rows.Count).End(xlUp).Offset(1) = Date
End Sub

You could change this to on the actual sheet

Private Sub Worksheet_Activate()
Range("O" & Rows.Count).End(xlUp).Offset(1) = Date
End Sub

 

[Brianwarnock]

If you want a log of every change then the worksheet_change event is the one to use.

Brian

 

[nashgas]

Thank You!!
That's exactly what I needed...