Detecting a change in a cell

[StevoWarby]

Hi all,

I am using Excel 2000, and have a question regarding something I wish to add to my work sheet.

I wish to add a new column that will automatically put in todays date, if a value in any of the other cells in the same row has been changed. (Basically to see when the row was last updated).

The whole work book is rather large and is constantly being updated by various colleagues so I really do not want to use the "Track Changes" functionality as this stores and shows more information than I want, and will over time increase the size of the file dramatically.

I'm guessing I will need some sort of macro, but do not know how to code them!

Any help is greatly appreciated,

Regards,

Stevo

 

[Andy B]

Hi

Have a look here:
http://www.mcgimpsey.com/excel/timestamp.html



--
Andy.

Hi all,

I am using Excel 2000, and have a question regarding something I wish to add to my work sheet.

I wish to add a new column that will automatically put in todays date, if

a value in any of the other cells in the same row has been changed.
(Basically to see when the row was last updated).

The whole work book is rather large and is constantly being updated by

various colleagues so I really do not want to use the "Track Changes"
functionality as this stores and shows more information than I want, and
will over time increase the size of the file dramatically.

 

[Ron de Bruin]

Hi

You can use the Change event to do this

Right click on a sheet tab and choose view code
Paste the code there
Alt-Q to go back to Excel

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column < 10 Then '10 = column J
' The date will be in column K
Cells(Target.Row, 11).Value = Format(Now, "mm-dd-yy hh:mm:ss")
End If
End Sub

For more info see

Event Macros, Worksheet Events and Workbook Events
DateTimeStamp in Column A, on first entry in any other column on row
http://www.mvps.org/dmcritchie/excel/event.htm#datetimestamp



--
Regards Ron de Bruin
http://www.rondebruin.nl

Hi all,

I am using Excel 2000, and have a question regarding something I wish to add to my work sheet.

I wish to add a new column that will automatically put in todays date, if a value in any of the other cells in the same row has

been changed. (Basically to see when the row was last updated).

The whole work book is rather large and is constantly being updated by various colleagues so I really do not want to use the

"Track Changes" functionality as this stores and shows more information than I want, and will over time increase the size of the
file dramatically.