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?