I have added the VBA for the Automatic Time Stamp and Update Time Stamp. This works great for all manually entered information. However, my initial entries are a paste of client demographics. If I am pasting over one client it works great!! If I paste over more than one at a time the auto stamp only auto populates for the first entry of the group. If I then use Control D (with the Table range including the date column) to populate the date down to the other rows this does not trigger the update cell to auto stamp. I work with hundreds of entries a day. Being able to bring multiple entries in with paste. Question: Is there anything I can add which will auto stamp each entry when multiple entries are brought in with paste values?
Code_Goes_HerePrivate Sub Worksheet_Change(ByVal Target As Range)
' Auto Date
Dim myTableRange As Range
Dim myDateTimeRange As Range
Dim myUpdateRange As Range
Set myTableRange = Range("B2:AQ800")
If Intersect(Target, myTableRange) Is Nothing Then Exit Sub
Application.EnableEvents = False
Set myDateTimeRange = Range("B" & Target.Row)
Set myUpdateRange = Range("AR" & Target.Row)
If myDateTimeRange.Value = "" Then
myDateTimeRange.Value = Now
End If
myUpdateRange.Value = Now
Application.EnableEvents = True
End Sub