Clarification

[Ruslan]

to make it clear...is it possible to make excel add automatically date in,
for example, A10 column when I enter information in B10 ?

 

[Earl Kiosterud]

Rusian,

This will put the latest date in column A any time you add or change any
information in B:

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("B")) Is Nothing Then
Cells(Target.Row, 1) = Now
End If
End Sub

This will put the date in column A the first time you put information into a
row in B, but won't change it if you add or change information later in a
row that already has a date in column A.

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("B")) Is Nothing And
IsEmpty(Cells(Target.Row, 1)) Then
Cells(Target.Row, 1) = Now
End If

Paste it from here into the sheet module in the VBE.

 

[pmayne181]

Hi
I have tried the formula from
http://www.mcgimpsey.com/excel/timestamp.html

but it returns a 01/01/1009 type thing and not the date
please explain I am a bit of an amature.

Regards

Pete

 

[Bernard Liengme]

If you meant to type 01/01/1900 then this is a date - 1 Jan 1900
Are you looking for a time? Try formatting the cell with Time
best wishes

 

[Suprdave74]

I too need to have static dates automatically entered when I enter
information in cell A or B and put the current static date in cell C, but I
have a workbook with several tabs in it and the source cells and target cells
are not in the same place on all of them. Does this work across all tabs or
do you need to specify what tab it affects?

In my application I am putting an "X" in a cell to indicate that I tested
the device (one column for pass and another for fail) and I would like the
current date to be inserted into a seperate cell. I tried using
=IF(J8="X",TODAY()," ") in the date column (for a passing situation, usually
not much fails), but every time I opened the workbook it would recalculate
and change the date to the current date.