Show date/time in a pre-determined column when data in row is edited...

Please Login or Register  to view this content.

This code allows me to enter in text/data in a row and then have the date and time show up in a box IN THE SAME ROW a certain number of boxes away.

How do I get the date and time to show up in cell J3 (for example) no matter what cell in Row 3 gets edited? I want just one cell at the far right of the row that keeps getting updated with date/time when a cell in that row is updated. I don't need specific cell date/time stamps... just to know when a row is updated.

So not like a target offset... I am going to have a table of data that will be getting updated. I want the cells in that column to the far right of the table to get updated with time/date when a cell in that row gets edited.

Thanks