Hi,

I am looking to find a way to add an automatic timestamp function to an excel sheet.

I have a long list of clients, and I want to see when I last made any specific row. I have them sorted in a table today, and I use filters to organize and search, and whenever I add a comment or change a phone number, I want to be able to go back and see when that was done.

As a super-simplified example, see the attachment. Whenever I make a change to column A to D, I want column E to immediately fill in the date and time.

Is there a way to do this or does this fall outside of the scope of what Excel can do?Timestamp example.xlsm

Any help or direction would be very much appreciated.

/Benkei