Creating a 'last updated' field in Excel 97

  • Thread starter Thread starter Stuart Matley
  • Start date Start date
S

Stuart Matley

I want a given cell in a spreadsheet to return todays date
if a value in a cell on the same row changes. How can I do
this?

Thanks
 
Hi Stuart,
You would need an Event macro and the cell that changes
would have to be a constant; otherwise, if would involve
another approach, such as the value the formula is based on.
http://www.mvps.org/dmcritchie/excel/event.htm#change

That should be enough information to get you started. Actual
coding would have to know which columns are involved. But
all parts of what you need can be gathered from snips of coding
from the above page.
 
Back
Top