referring to formula in a non active cell from active cell

[nickname]

Is there a way to refer to the formula from (not value of) a non
active cell into a formula in an active cell?

For example,

A1: =A2+A3 [non active cell]

Would like to insert above formula (A2+A3) into active cell's formula
by referring to A1, non active cell.

B1: = ?function?(A1) + B4 + B5 [active cell]

Here are the values of cells:
B2 = 2
B3 = 3
B4 = 4
B5 = 5

So the value of B1 would be 2+3+4+5 or 14.

Thanks in advance for any guidance.

 

[Dave Peterson]

There's not a function in excel that lets you look at the formula.

You'd have to use some sort of macro.

If I were doing this for a single cell, I'd just select A1 and select the
formula in the formula bar and hit ctrl-c (to copy it).

Then select the other cell and position the cursor in the formulabar right after
the equal sign and ctrl-v.

You may want to avoid copying the leading equal sign and you may want to add ()
around the portion of the formula you pasted.

Is there a way to refer to the formula from (not value of) a non
active cell into a formula in an active cell?

For example,

A1: =A2+A3 [non active cell]

Would like to insert above formula (A2+A3) into active cell's formula
by referring to A1, non active cell.

B1: = ?function?(A1) + B4 + B5 [active cell]

Here are the values of cells:
B2 = 2
B3 = 3
B4 = 4
B5 = 5

So the value of B1 would be 2+3+4+5 or 14.

Thanks in advance for any guidance.