formula for coping a cell from a diffent sheet
 

i would like to copy a cell from a different sheet onto the one sheet i am
viewing
is there a formula for that?

formula for coping a cell from a diffent sheet
 

the cell contains TEXT or a word not a number also

"Shallow" wrote:

i would like to copy a cell from a different sheet onto the one sheet i am
viewing
is there a formula for that?

formula for coping a cell from a diffent sheet
 

You can't copy by formula, but you can link by formula:

=Sheet3!B9

will display the value in B9 on Sheet3
--
Gary''s Student - gsnu200805


"Shallow" wrote:

i would like to copy a cell from a different sheet onto the one sheet i am
viewing
is there a formula for that?

formula for coping a cell from a diffent sheet
 

SWEET!
THANK YOU

"Gary''s Student" wrote:

You can't copy by formula, but you can link by formula:

=Sheet3!B9

will display the value in B9 on Sheet3
--
Gary''s Student - gsnu200805


"Shallow" wrote:

i would like to copy a cell from a different sheet onto the one sheet i am
viewing
is there a formula for that?

formula for coping a cell from a diffent sheet
 

You are welcome!

Be sure to remember that a blank in B9 will display as 0 in the display cell.
--
Gary''s Student - gsnu200805


"Shallow" wrote:

SWEET!
THANK YOU

"Gary''s Student" wrote:

You can't copy by formula, but you can link by formula:

=Sheet3!B9

will display the value in B9 on Sheet3
--
Gary''s Student - gsnu200805


"Shallow" wrote:

i would like to copy a cell from a different sheet onto the one sheet i am
viewing
is there a formula for that?

formula for coping a cell from a diffent sheet
 

You can actually copy it that way without any typing, especially handy if
you want to do more than one cell

Copy the cell/cells, got to where you want it and do editpaste special and
select paste link

--


Regards,


Peo Sjoblom

"Shallow" wrote in message
...
SWEET!
THANK YOU

"Gary''s Student" wrote:

You can't copy by formula, but you can link by formula:

=Sheet3!B9

will display the value in B9 on Sheet3
--
Gary''s Student - gsnu200805


"Shallow" wrote:

i would like to copy a cell from a different sheet onto the one sheet i
am
viewing
is there a formula for that?