right click sheet tabview codecopy/paste this. Now when you put anything
in cell a1 it will be added to a list starting at the next available row in
col C. Why Jones? You may want to delete the Target="Jones" line.

Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
If Target.Address < "$A$1" Then Exit Sub
lr = Cells(Rows.Count, "c").End(xlUp).Row + 1
Cells(lr, "c") = Target
Target = "Jones"
Application.EnableEvents = True
End Sub

--
Don Guillett
SalesAid Software

"Yendorian" wrote in message
...
In Excel Pro 2003, I am trying to enter data from one cell only (A1 €“
Jones)
and have it saved in another column of cells.(Column C1). If I enter
€˜=$A$1
in cell C1, I get the name in that cell €“ which is fine.
My problem is that I now want to enter a new name from cell (A1 €“ this
time
Brown) and have it saved in the new cell C2 without changing the Jones
name
in C1, but of course the formula €˜=$A$1 puts Brown in the new cell. C2
and
changes
C1 to Brown also.
Ideally I want to enter Jones, Brown, Smith, Evans, Davis etc. into cell
A1
and have them fixed iin Column C giving a list of different names in
Column
C. Any help gratefully received.