Copy / paste values

Hello,

I need help in VBA. I know this is very simple but i am not familiar with the codes.

In a blank cells for example is B2 to B10. If i type something in any of the cells, i need a timestamp on C column corresponds to the rows where they typed. I was able to do it in excel but it refreshes whenever the file or formula had been refresh.

Thanks.

Hi

Try a sheet event macro

Private Sub Worksheet_Change(ByVal Target As Range)
  On Error GoTo prob
  Application.EnableEvents = False
  If Intersect(Target, Range("B2:B10")) Then
    Target.Offset(0, 1).Formula = "=now()"
    Target.Offset(0, 1).NumberFormat = "dd/mm/yy hh:mm:ss"
    Target.Offset(0, 1).Value = Target.Offset(0, 1).Value
  End If
prob:
  Application.EnableEvents = True
  
End Sub

rylo

Sorry Rylo, i really cant encode vb codes. can you please attach a sample file or worksheet? thank you so much!!!

Hi

Open a blank new workbook, right click on the sheet tab, select view code, then paste in the code from #2. Now go back to the sheet, and enter something in B2. It should put in the date / time stamp into C2.

rylo