Timestamp changes

[Benkei]

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

[alansidman]

Put this in the worksheet event for the sheet you are working on.

Please Login or Register  to view this content.

Open the VBE (Alt +F11). In the left window, select the sheet you are working in. Double click. Right window appears. Paste code and save and close.

[alansidman]

Thanks for the Rep and if that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[Benkei]

Thanks a lot! :D