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.