Formula function

[SDMFG]

Is there a function that will display the formula in a cell? For example, I
have a cell that is a formula, ='All Managers'!E2, which returns a value.
However, I would like to have that formula displayed in another cell. Is
there an existing function for this?

Thanks!

 

[RagDyeR]

You could copy the formula from the Formula Bar so that the references don't
change,
then paste to another cell and just delete the = sign.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

Is there a function that will display the formula in a cell? For example, I
have a cell that is a formula, ='All Managers'!E2, which returns a value.
However, I would like to have that formula displayed in another cell. Is
there an existing function for this?

Thanks!

 

[SDMFG]

I would like a function that would do this automatically, though.

 

[Peo Sjoblom]

You would need VBA then or Excel4 macro


For VBA


http://www.mvps.org/dmcritchie/excel/formula.htm


http://www.mvps.org/dmcritchie/excel/install.htm#install



Or you could do insert>name>define and assume that the formula is in A6

then use

=GET.CELL(6,Sheet1!$A$6)

in the refers to (replace Sheet1 with your sheet name)


You could call it GetFormula


then use

=GetFormula



--


Regards,


Peo Sjoblom

 

[SDMFG]

The VBA site helped, thank you.

You would need VBA then or Excel4 macro


For VBA


http://www.mvps.org/dmcritchie/excel/formula.htm


http://www.mvps.org/dmcritchie/excel/install.htm#install



Or you could do insert>name>define and assume that the formula is in A6

then use

=GET.CELL(6,Sheet1!$A$6)

in the refers to (replace Sheet1 with your sheet name)


You could call it GetFormula


then use

=GetFormula



--


Regards,


Peo Sjoblom