S
Shallow
i would like to copy a cell from a different sheet onto the one sheet i am
viewing
is there a formula for that?
viewing
is there a formula for that?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
Shallow
the cell contains TEXT or a word not a number also
G
Gary''s Student
You can't copy by formula, but you can link by formula:
=Sheet3!B9
will display the value in B9 on Sheet3
=Sheet3!B9
will display the value in B9 on Sheet3
S
Shallow
SWEET!
THANK YOU
THANK YOU
Gary''s Student said:You can't copy by formula, but you can link by formula:
=Sheet3!B9
will display the value in B9 on Sheet3
G
Gary''s Student
You are welcome!
Be sure to remember that a blank in B9 will display as 0 in the display cell.
Be sure to remember that a blank in B9 will display as 0 in the display cell.
P
Peo Sjoblom
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 edit>paste special and
select paste link
--
Regards,
Peo Sjoblom
you want to do more than one cell
Copy the cell/cells, got to where you want it and do edit>paste special and
select paste link
--
Regards,
Peo Sjoblom