Add a date stamp to a cell on the same row where any other cell may have updated

Copper Contributor

In a table of data, I'm trying to assign a column ("AJ") to record the date if any cell within the same row, "A" to "AI" may have been changed.

 

Data range = A6:AI1000

Date recording column = AJ

This would then be applied to AJ6:AJ1000 to record each line item's update history.

 

I'd like to be able to undo as well, I've seen some VBA codes wipe the memory once a code has run.

 

Any help much appreciated.

0 Replies