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

In Excell - How do you get infomation typed in one cell to appear.
 

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

Hi!

If you enter data in cell A1 and you want that data to
also appear in cell D10. In cell D10 enter this formula:

=IF(A1="","",A1)

Biff

-----Original Message-----
In Excel -
How do you get information typed in one cell to appear in
another
pre-choosen cell location.
.

Doesn't =A1 do all that the formula does ;-)

Bob


"Biff" wrote in message
...
Hi!

If you enter data in cell A1 and you want that data to
also appear in cell D10. In cell D10 enter this formula:

=IF(A1="","",A1)

Biff

-----Original Message-----
In Excel -
How do you get information typed in one cell to appear in
another
pre-choosen cell location.
.

I would guess that it depends on whether or not you want a 0 displayed, if
the source cell is empty.
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

"Biff" wrote in message
...
Hi!

If you enter data in cell A1 and you want that data to
also appear in cell D10. In cell D10 enter this formula:

=IF(A1="","",A1)

Biff

-----Original Message-----
In Excel -
How do you get information typed in one cell to appear in
another
pre-choosen cell location.
.