Insert date when a cell is changed

J

jen2018

Hi

Is there a way to insert the current date into a cell in column D when a
cell on the same row is changed?

I need a method that doesn't involve a macro as many people will be updating
the spreadsheet and won't enable their macros
 
W

Wigi

If you don't want to use macro's, you're very limited.

You could write a function that sets the date, but this date will not be
fixed and will change (the TODAY() function for instance).

Also, you will need to drag down that formula far enough to be sure to cover
enough rows. Not very appealing I guess.
 
J

jen2018

Thanks but even with the formula option it only works when I have my macros
on. Is there a way round this?
 
G

Gord Dibben

If you use John's circular reference method you don't need macros enabled.

That method is posted above the worksheet_change event method.


Gord Dibben MS Excel MVP
 
Top