Excel time/date stamp of a cell change

[SemiAuto40]

Hey All, This must be one of the most common questions in Excel but all of the "solutions" that I have found while searching do not work (or I am not implementing properly).

This is the problem: once a value changes in a cell on Sheet1, I need the corresponding cell in Sheet2 to get the Now() value when the cell on Sheet1 was changed. Ex: Sheet1!E6 gets a value - then Sheet2!E6 shows something like 2/17/12 8:45:33.

I want this to be generic enough to apply to a range of cells, not just a one time event.... and such that all of the cells in Sheet2 holding the Now() value don't all display the exact same time like my failed attempts do.

If VB is involved I need specific instructions on where to put in and please phrase it in a 4th grade level.

Please My sanity is at stake here.

 

[Joe4]

Excellent!! I am really happy that I signed up for this forum.

Your welcome!
And welcome aboard!

 

[ufgatorchick]

Hi,

I'm new to the group, and a real novice at Excel. Hoping to learn a lot from you all!

I keep a project pipeline for my company, where Column I is my note field, and Column H is my Date Updated field. I'm trying to configure the sheet so that when I make any change to a cell in Column I, the adjacent cell in Column H auto-updates to the current date.

I have been trying to figure this out for hours...........

If you have any advice, please let me know.

Thanks!
Jessica

 

[Joe4]

I keep a project pipeline for my company, where Column I is my note field, and Column H is my Date Updated field. I'm trying to configure the sheet so that when I make any change to a cell in Column I, the adjacent cell in Column H auto-updates to the current date.

Welcome to the Board!
This variation should do that:

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Column = 9 Then Target.Offset(0, -1) = Date
End Sub

 

[ufgatorchick]

Thank you so much! This worked perfectly (and helped me figure out how to do something similar with another set of columns)! I'm so excited to become better at Excel!
Thanks again!
Jessica

 

[Joe4]

Your welcome!

 

[mattharesign]

Welcome to the Board!

Sure, just add the condition to the IF statement, i.e.
change:

If Target.Count = 1 Then

to:

If (Target.Count = 1) and (Target = "Completed") Then

Hi

How can i get this to work if anything other than specific text string, say "Hello", is entered into a specific column? so if goodbye is entered (or anything else), it prints date and time in corresponding cells, if hello is, it doesnt.

I have this so far:

If (Target.Column = 17) and (target.column <> "Hello") Then
Application.EnableEvents = False
Target.Offset(, 1).Value = Date
Target.Offset(, 2).Value = Time
Application.EnableEvents = True
End If
End Sub

But it doesn't do anything at all. I'm not sure why. Bah.

 

[VoG]

Try

If Target.Column = 17 And Target.Value <> "Hello" Then

 

[mattharesign]

Try

If Target.Column = 17 And Target.Value <> "Hello" Then

you sir, are a gentlman and a scholar. works perfectly.

 

[tobiasdon]

referring to the original question, how would you remove or clear the time/date stamp if the original cell was cleared

 

[Joe4]

referring to the original question, how would you remove or clear the time/date stamp if the original cell was cleared

I posted various blocks of code in this thread. Is there a particular block of code that would like to apply that logic to?