SOLVED

Timestamp excel cell when change is made

Copper Contributor

I'm working on a tracker for applications. I want a cell timestamp to be entered into a cell and updated every time cells in a specified column are changed. Example: when B2 changes D2 updates with the current date. I've been digging through what I found online. Three people will regularly be making changes to this tracker. I've tried a couple macros but every time I make changes it messes up the table. I've removed the table and the only way to move the row without it becoming a mess is to move the whole row. We have a reference chart next to the tracker so that isn't workable. I can easily make the fixes necessary however my coworkers don't have the same skillset as me. I'm looking for a user friendly solution.

2 Replies
best response confirmed by Rehhea (Copper Contributor)
Solution

@Rehhea 

Attached is a small example file with a timestamp.

Code is in the file.

 

My answers are voluntary and without guarantee!

 

Hope this will help you.

Was the answer useful? Mark as best response and Like it!

This will help all forum participants.

Thank you so much, this worked perfect.
1 best response

Accepted Solutions
best response confirmed by Rehhea (Copper Contributor)
Solution

@Rehhea 

Attached is a small example file with a timestamp.

Code is in the file.

 

My answers are voluntary and without guarantee!

 

Hope this will help you.

Was the answer useful? Mark as best response and Like it!

This will help all forum participants.

View solution in original post