You can do this with a worksheet_change event macro which is told to use
date in the cell if cells in the row have changed.

--
Don Guillett
SalesAid Software

"Mike200575" wrote in message
...
In a sheet used as a data base, how do I have the current date updated or
changed when the data changes in a record or row. I would like this to
show
when that record has been modified with out manually changing that cell.