software

Here is the scenario:

I have a tracking worksheet in which multiple people update locations
and inspection dates for equiptment, and I have spent litterally 1/2 of
the day today trying to figure how to have a cell that will simply
through the current date of when anywhere on that row is updated. the
most i was able to find was an =if statement that utilized the 'call'
function, which is defunct in all versions past '97. I spent a couple
hours putzin around with differant IF statements useing the TODAY()
function, but all it did was update the day on all of the cells as soon
as the worksheet was opened
I have been ripping out what little hair i have left all day over this
stupid thing!

Thanks

Josh--
vaderj
------------------------------------------------------------------------
vaderj's Profile: www.excelforum.com/member.php...oamp;userid=33801
View this thread: www.excelforum.com/showthread...hreadid=535715You need to use VBA code. In the sheet module (right-click the
tab and choose View Code), use something like the following:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 Then
Application.EnableEvents = False
Target.EntireRow.Cells(1, quot;Bquot;).Value = Now
Application.EnableEvents = True
End If
End Sub
This will put in column B the date and time that the
corresponding cell in column A is changed.--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

quot;vaderjquot; gt;
wrote in message
...
gt;
gt; Here is the scenario:
gt;
gt; I have a tracking worksheet in which multiple people update
gt; locations
gt; and inspection dates for equiptment, and I have spent
gt; litterally 1/2 of
gt; the day today trying to figure how to have a cell that will
gt; simply
gt; through the current date of when anywhere on that row is
gt; updated. the
gt; most i was able to find was an =if statement that utilized the
gt; 'call'
gt; function, which is defunct in all versions past '97. I spent a
gt; couple
gt; hours putzin around with differant IF statements useing the
gt; TODAY()
gt; function, but all it did was update the day on all of the cells
gt; as soon
gt; as the worksheet was opened
gt; I have been ripping out what little hair i have left all day
gt; over this
gt; stupid thing!
gt;
gt; Thanks
gt;
gt; Josh
gt;
gt;
gt; --
gt; vaderj
gt; ------------------------------------------------------------------------
gt; vaderj's Profile:
gt; www.excelforum.com/member.php...oamp;userid=33801
gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=535715
gt;