Forum Discussion
Timestamp excel cell when change is made
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.
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.
- NikolinoDEGold Contributor
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.
- RehheaCopper ContributorThank you so much, this worked perfect.