Insert date whenever cell is updated (not edited)

Hello everyone

I'm using this macro to insert the time and date into another cell whenever a cell within a column is edited. However I want to try the same thing, but with cells that are not edited manually(they are vlookup-ing to another location), so that when the vlookup returns something different than before, the date/time cell is updated.

Formula:

Please Login or Register  to view this content.

Thanks

You need an extra column to store the value that the formula is currently returning.

So, column 40 has the formulas, 41 has the date, and 42 is used to store the value for the change-check.

Please Login or Register  to view this content.