User needs to track entries in cells

[SSolano]

User wants the entries in a cell to appear in a second
sheet when entered, but also move down one line to
indicate each occuring change.
I thought track changes history report would be okay, but
it doesn't serve the purpose, since he wants the results
to remain on the file.
Any ideas?

 

[JE McGimpsey]

One way:

Put this in the worksheet code module (right-click the sheet tab and
choose View Code):

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
With Target(1)
If .Address(False, False) = "A1" Then _
Sheets("SHeet2").Cells(Rows.Count, 1).End( _
xlUp).Offset(1, 0).Value = .Value
End With
End Sub