Locking info in cells Yendorian 6/14/2007 2:12:01 PM 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.

Re: Locking info in cells "Peter Jamieson" <pjj[ at ]KillmapSpjjnet.demon.co.uk> 6/14/2007 4:08:18 PM You're in the wrong group - if you really want to do that, you should ask in an Excel group. Peter Jamieson "Yendorian" <Yendorian[ at ]discussions.microsoft.com> wrote in message news:BD895128-C1F2-44A8-91F5-5006DF5FF918[ at ]microsoft.com... [Quoted Text] > 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. > >