Not exactly sure what your scenario is but have you checked out the
'INDIRECT' function? This references a formula in another cell and
effectively incorporates it within the formula with the INDIRECT function
within it.

Helpful? Hit Yes.

"fasta13" wrote:

Is there a function in excel that I am missing which will reference the
formula in a cell and not the value (recalculating that formula in the new
cell)?

If not, can someone who has a macro which does this post it please, it would
be very helpful.