View Single Post
  #1   Report Post  
Kev Nurse
 
Posts: n/a
Default


Mark wrote in message
...
In Excel -
How do you get information typed in one cell to appear in another
pre-choosen cell location.


You need to use the formula bar. Select the cell that you want to copy the
data into (say, A1). Then click on the " = " button on the formula bar.
(This means that the selected cell (A1) will show the result of a formula).
Then select the source cell (say, B1) and click enter (or click on the tick)
button. Whatever info is entered into B1 will also be displayed in A1.
Point to note: if you cut and paste cell B1 to any other cell, then the
info in cell A1 will be linked to the new address of cell B1. Ordinarily,
this is a good thing. However, it might not be what you want.

Regards
Kev