Not sure how you've got it setup currently, but to input time stamps, you
could try this event macro. Right click on sheet tab, view code, paste this
in. You should probably save your previous time stamps and make them static,
so they don't keep changing.

Private Sub Worksheet_Change(ByVal Target As Range)

'Change letter to match column where you are inputting data
If Target.Address Like "$A$*" Then
'Note: Change 2nd number to number of columns to offset time stamp
Target.Offset(0, 1).Value = Now
End If

End Sub
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Marvin" wrote:

I wanted to have the date and time automatically appear whenever I entered an
item in my spreadsheet. However, each time I entered a new item, all the
dates and times of the previous items changed as well.

I want to enter items on different days, but I want to track the previous
dates and times of items entered days before. What is happening is that the
next day all the dates and times change. Is there a way to prevent this from
happening?

Marvin