Adding a Date modified cell for each Row???

[Lewie]

Is there some way to have a cell that reports a date when a cell within an existing range has been populated?

 

[AlphaFrog]

If you search this site (search for something like; date time stamp range site:mrexcel.com), you'll find several threads on this topic. Unfortunately you gave no specifics as to what range of cells are modified and where you want the date stamps, etc.

This thread is a good one to start with, but there are many others. They are mostly variations on the same theme.
http://www.mrexcel.com/forum/excel-questions/614541-excel-time-date-stamp-cell-change.html

 

[kvsrinivasamurthy]

What is the range of data.where date is to be displayed.

 

[Lewie]

As columns A:D are populated with what stage a drawing is at, I want the date to automatically appear in E 2:5. I only need the date for the right most cell at each instance.

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Designed
[/TD]
[TD]Checked
[/TD]
[TD]Engineered
[/TD]
[TD]Approved
[/TD]
[TD]Date
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]BLE
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Designed Date
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]
[/TD]
[TD]No Date
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]BLE
[/TD]
[TD]ATI
[/TD]
[TD]JAG
[/TD]
[TD][/TD]
[TD]Engineered Date
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]BLE
[/TD]
[TD]GFB
[/TD]
[TD][/TD]
[TD][/TD]
[TD]Checked Date
[/TD]
[/TR]
</tbody>[/TABLE]

 

[kvsrinivasamurthy]

Worksheet event is used
Right click on Sheet Tab. Paste the below code.Close the window
If you make changes in range A2:D5, Same row E column gets Date of today.Range A2:D5 can be changed as per your requirement.

Private Sub Worksheet_Change(ByVal Target As Range)

Application.EnableEvents = False
If Not Intersect(Range("A2:D5"), Target) Is Nothing Then
    If Target <> "" Then
    Range("E" & Target.Row) = Date
    End If
End If
Application.EnableEvents = True


End Sub

 

[Lewie]

Nice.
Thanks for that can I also output in Colum F the right most initials and each instance?
Also if A2 - D2 then get deleted and are blank, the date field goes back to blank?

 

[kvsrinivasamurthy]

I am not clear about explanation. Give sample table showing what is required.