I suppose you could create a macro, but generally speaking if you want the
value in one cell to be dependent upon the value in another, the way to do it
is entering the second cell reference in the first cell; i.e., =C3 in B3.
Why would you want to make it harder?

Dave
--
Brevity is the soul of wit.


" wrote:

I'm trying to create a formula in one cell (let's say C3), and I want
the results of that cell to show up in B3. Is there a way to have the
results of the formula in C3 show up in B3 without having to put "=C3"
in my B3 Cell?