Formulas can only "pull" data not "push" it.

You would need VBA code to populate B3 without a formula.


Gord Dibben MS Excel MVP

On 29 Jan 2007 10:42:15 -0800, 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?