Excel formula question - sending results to another cell

[jeremy.a.williams]

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?

 

[Gord Dibben]

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

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


Gord Dibben MS Excel MVP

 

[Guest]

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

 

[Guest]

Put the same formula in B3 that you use in C3

 

[Bill Ridgeway]

You can only pull data. You can't push data. (Remember PEEK & POKE
anyone?)

Regards.

Bill Ridgeway
Computer Solutions

 

[jeremy.a.williams]

Thanks for all your help!

The purpose behind the question is that I'm creating a document that
others will be working on and I figured there would be less chance of
some formulas being deleted if I could hide the formulas and push the
data to other cells.

- Jeremy

 

[Guest]

That's what sheet protection is for. Set the cells in which your users will
enter data to unlocked then protect the sheet. Use a password if necessary
then the formulae will be relatively safe.