Help with changing date automatically when cell value was changed.

Hi everyone,

i have a links tracking spread sheet, it has 3 columns: link, notes & date.

whenever i'm changing the link/s i'm adding the date manually.

since i'm changing the links very often, i wonder if there is a way to make the date change automatically whenever the link cell has changed?

basically i need the "date" column to change to date the "link" column was changed.

i hope that's clear enough, attaching a workbook to the post.

Thanks!

Hi TMS,

Sorry i'm a bit newbie to excel VBA.

looked online how to do what you suggested and i'm a bit lost.

found a VBA code that adds a note with the changed time to any changed cell, this is close but not what i want.

VBA code:

Please Login or Register  to view this content.

how am i getting the data in the note to be written in the "date" cell?

any tips on what to do it?

Thanks!