Insert date when a cell is changed

  • Thread starter Thread starter jen2018
  • Start date Start date
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
 
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.
 
Thanks but even with the formula option it only works when I have my macros
on. Is there a way round this?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert blank row after change in cell value not working. 1
Excel Worksheet_change with 2 functions to insert date and hyperlink window 0
Excel Excel - Macro to Insert Cell 0
Help to create a macro 2
Macro to insert a line when a value changes in a range 1
Date Stamp 7
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
Insert rows and keep merged cells in the inserted row 1

Back
Top