Insert automatic date and time stamp in a cell if any cell of the same row is edited

Use an event macro. Say, for example, data is entered in columns A thru K starting in the second row. We want an automatic date/time stamp in column L if data is either entered in a row or data is changed in a row. Insert the following macro in the worksheet code area:

Please Login or Register  to view this content.

Because it is worksheet code, it is very easy to install and automatic to use:

1. right-click the tab name near the bottom of the Excel window
2. select View Code - this brings up a VBE window
3. paste the stuff in and close the VBE window

If you have any concerns, first try it on a trial worksheet.

If you save the workbook, the macro will be saved with it.


To remove the macro:

1. bring up the VBE windows as above
2. clear the code out
3. close the VBE window

To learn more about macros in general, see:

http://www.mvps.org/dmcritchie/excel/getstarted.htm

To learn more about Event Macros (worksheet code), see:

http://www.mvps.org/dmcritchie/excel/event.htm

Macros must be enabled for this to work!

I will respond shortly..................

First remove the previous version
Then install this version:

Please Login or Register  to view this content.

Hello,

The Time and Date stamp vanishes after I remove old values within the cell range (Even though the new data I entered is still there)?.

The clearing of the date stamp is in accordance to your request:

What happens if I add value in a cell within the range and if I choose to clear the same then how to make the stamp go away?

This what you asked for in post #11:

I need the date stamp to remain if I delete old existing data prior to new data insertion.

When you clear all the input cells of a row the time stamp will automatically clear.
To manually remove the time stamp just empty the cell, it will remain clear untill you fill in or change one of the input cells of that row.

Thanks. If I clear the time stamp, it appears again. The same thing happens if I delete or insert a column.The time stamp shows even if there is no data in the new cells.

Regards.

I reworked the code, excluded some columns in the target range and now it seems to work as required..... fingers crossed. Thank you all for helping as ever.