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?