Displaying formula from one workbook in another

Barb Reinhardt · Feb 17, 2006

I have the following formula in Workbook1.xls Sheet1
=offset(blah blah blah)
I want to display that formula in Workbook2.

How can I display this formula?

Thanks in advance,
Barb Reinhardt

Peo Sjoblom · Feb 17, 2006

You would need a UDF like

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

=getformula([Book2]Sheet1!$A$1)

you can make that UDF into an add-in so it is available

Or download Laurent Longre's excellent Morefunc (personally I think it is
the best add-in for Excel)

http://xcell05.free.fr/

FORMULATEXT

is the name of the function

English descriptions here

http://www.rhdatasolutions.com/morefunc/

--
Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon