Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Locking info in cells
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. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Locking info in cells
You're in the wrong group - if you really want to do that, you should ask in
an Excel group. Peter Jamieson "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. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need help with locking or protecting cells. | New Users | |||
Locking word 2003 table cells | Page Layout | |||
Locking Cells in a Table So They Cannot Be Typed In | Tables | |||
info from cells to access | Microsoft Word Help | |||
Locking Cells in Word | Tables |