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.

​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.  Read More

​