Solved Record the date a cell in a given range was last changed

Microsoft Excel 2003 (full product)
February 13, 2012 at 13:17:05
Specs: Windows 7, 2Ghz / 4GB
I have a column positioned at AL that records remarks relevant to each row of data. I need to record the date the each of the AL cells were last changed (date to be shown in Column AM). The remarks are updated by 6 different users regularly. There are up to 400 rows of data, but the users would only update a few rows at a time. If the user name can also be captured that would be a bonus.

Therefore, if a user updated remarks in cells AL3, AL37 and A345 the date they carried out the change would appear in AM3, AM37 and AM345.

I have tried a couple of VBA examples from the forum but haven't found one that I was able to modify to fit my needs. Appreciate any help on this.


See More: Record the date a cell in a given range was last changed

Report •


#1
February 13, 2012 at 13:45:35
✔ Best Answer
re: "if a user updated remarks in cells AL3, AL37 and A345 "

A345? A typo perhaps?

Try this:

Private Sub Worksheet_Change(ByVal Target As Range)
 If Target.Column = 38 And Target.Cells.Count = 1 Then
     Range("AM" & Target.Row) = Date
 End If
End Sub

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
February 13, 2012 at 13:57:59
DerbyDad03 you are a star, had seen one of your earlier posts for something similar but as I mentioned I couldn't modifed it for the purpose above.

The answer above is perfect, now I will try to add the the user name.


Report •
Related Solutions


Ask Question