Another date function question
 

I am working on a large excel list that tracks different salesmens
activities. They need update their customer info on a regular basis.
There is one row per customer, this row also contains a cell with a
date for last update. What I am looking for is: I want the date cell
on each row to automatically update when any cell on the row is
changed. I know this can be done... but I'll danged if I can find it.
I welcome any and all suggestions.

Thanks in advance. :confused:


--
mendozalaura
------------------------------------------------------------------------
mendozalaura's Profile: http://www.excelforum.com/member.php...o&userid=16118
View this thread: http://www.excelforum.com/showthread...hreadid=275614

You're not missing anything. This requires a VBA event macro, specifically a
Worksheet_Change macro. Are you familiar with macros?

On Fri, 5 Nov 2004 08:14:02 -0600, mendozalaura
wrote:


I am working on a large excel list that tracks different salesmens
activities. They need update their customer info on a regular basis.
There is one row per customer, this row also contains a cell with a
date for last update. What I am looking for is: I want the date cell
on each row to automatically update when any cell on the row is
changed. I know this can be done... but I'll danged if I can find it.
I welcome any and all suggestions.

Thanks in advance. :confused: