Macro perhaps? Excel 2000 1

[slirper]

I need to achieve the following:

If I input data into one cell (usually numerical figures) I want the data in the adjacent cell to update automatically with the current DATE. It should only do this when the numerical data is changed and not when the file is opened.

Thanks for the help.

 

[Bowers74]

Enter the following code into the Worksheet object that contains the Input cells.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 And IsNumeric(Target) Then
    Target.Offset(0, 1).Value = Format(Now(), "Short Date")
End If
End Sub

This code assumes that your input cells are in column A, if they are elsewhere you need to change the Target.Column = 1.

You can remove the InNumeric(Target) if it doesn't matter what is entered into the input cell.

I hope that this puts you on the right track.



If you can't be "The Best", be the best at what you can!!!

Never say Never!!!
Nothing is impossible!!!

 

[mosmas]

You can also use this formular:

=IF(ISNUMBER(A1),NOW(),"Not Numeric&quot

I hope this hepls.

Mosmas