Creating a 'last updated' field in Excel 97

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
 
D

David McRitchie

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.
 
Top