Updating Time when a field has been modified

[Joshua Vista Star]

-- This one is a toughy!!!!!!!

Goal:
I have two colums and multiple rows. I would like to updated the first row
with
the time that the second row was modified.

Problem:
When ever the second row is modifed every-time stamp in the first colum is
updated.

I need to update the time in each row independently - and keep it from being
modified or updated.

[David McRitchie]

Hi Joshua,
To enter the time as a constant use Ctrl+Shift+colon
To enter the date as a constant use Ctrl+Shift+semicolon

To enter the date or time automatically when you update another column
on the row, you can use an event macro, see
http://www.mvps.org/dmcritchie/excel/event.htm#autotime
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Joshua Vista Star" <Joshua Vista [email protected]> wrote in message
news:[email protected]...
> -- This one is a toughy!!!!!!!
>
> Goal:
> I have two colums and multiple rows. I would like to updated the first row
> with
> the time that the second row was modified.
>
> Problem:
> When ever the second row is modifed every-time stamp in the first colum is
> updated.
>
> I need to update the time in each row independently - and keep it from being
> modified or updated.

[Ardus Petus]

Private Sub Worksheet_Change(ByVal Target As Range)
With Target
If .Column = 2 Then
.Offset(, -1).Value = Now
End If
End With
End Sub

HTH
--
AP

"Joshua Vista Star" <Joshua Vista [email protected]> a écrit
dans le message de
news:[email protected]...
> -- This one is a toughy!!!!!!!
>
> Goal:
> I have two colums and multiple rows. I would like to updated the first row
> with
> the time that the second row was modified.
>
> Problem:
> When ever the second row is modifed every-time stamp in the first colum is
> updated.
>
> I need to update the time in each row independently - and keep it from
being
> modified or updated.