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?