Auto inserting date of change

[patti]

I have a spreadsheet that I would like to have today's
date automatically insert in the next column when I change
the entry in the first column.

For example:
Colume A = 5 Colume B = 03/04/04

Today I change Column A to 6; How can I get Column B to
automatically change to 03/05/04?

Thank you.

 

[Frank Kabel]

Hi
this can only be done with VBA (otherwise the entry will change with
each re-calculation). Have a look at
http://www.mcgimpsey.com/excel/timestamp.html
for creating a timestamp

 

[Gavin Holts]

This automatically puts the date in A when data goes into B Paste into veiw
code on your worksheet

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 2 And Target <> "" Then Target.Offset(, -1) = Date
End Sub

--

..
..
..
..