Forum Discussion

Rehhea's avatar
Rehhea
Copper Contributor
Jun 14, 2024

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.

  • 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.

  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor

    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.

    • Rehhea's avatar
      Rehhea
      Copper Contributor
      Thank you so much, this worked perfect.

Resources