software

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

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
www.mvps.org/dmcritchie/excel/event.htm#autotime
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;Joshua Vista Starquot; lt;Joshua Vista gt; wrote in message
...
gt; -- This one is a toughy!!!!!!!
gt;
gt; Goal:
gt; I have two colums and multiple rows. I would like to updated the first row
gt; with
gt; the time that the second row was modified.
gt;
gt; Problem:
gt; When ever the second row is modifed every-time stamp in the first colum is
gt; updated.
gt;
gt; I need to update the time in each row independently - and keep it from being
gt; modified or updated.
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

quot;Joshua Vista Starquot; lt;Joshua Vista gt; a écrit
dans le message de
...
gt; -- This one is a toughy!!!!!!!
gt;
gt; Goal:
gt; I have two colums and multiple rows. I would like to updated the first row
gt; with
gt; the time that the second row was modified.
gt;
gt; Problem:
gt; When ever the second row is modifed every-time stamp in the first colum is
gt; updated.
gt;
gt; I need to update the time in each row independently - and keep it from
being
gt; modified or updated.