|To auto-update the Date you need to use a Worksheet_Change event macro which will fire whenever there is a change to the worksheet.|
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row > 5 Then
Application.EnableEvents = False
Range("A" & Target.Row) = Date
Application.EnableEvents = True
As far as the MAX function, I don't see where you are using it.
I don't know if this is what you want, but if you put this in C5 it will return StxSoul since that is the name associated with the name in Column B that is in the same row as the MAX value in Column C (62)
Drag it over to D5 and it will return OrinVerido since that name corresponds to 46, the MAX value in Column D.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.