Help with Extracting Formula from another Cell and Incrementing

[jkaneff]

I want to extract the formula in a cell of another worksheet and then increment that extracted formula by 1. For instance if the formula in another cell is "=B3" then I want the formula in my current cell to be "=B4".

 

[njimack]

If you have Excel 2013 or later, the below should work:

=INDIRECT(MID(FORMULATEXT(A1),2,MIN(FIND({1,2,3,4,5,6,7,8,9},FORMULATEXT(A1)&"123456789"))-2)&1+RIGHT(FORMULATEXT(A1),LEN(FORMULATEXT(A1))-MIN(FIND({1,2,3,4,5,6,7,8,9},FORMULATEXT(A1)&"123456789")-1)))

 

[Peter_SSs]

Welcome to the MrExcel board!

1. I think it would be helpful if you told us a bit more about what you have and what you are trying to do.

2. I suspect that your formula won't always be as simple as the example you have given. For example, could it be like any of the following and, if so, what results would you be expecting?
=B3+1
=SUM(A4:F4)
=B3*K22
etc

3. What do you mean by "my current cell"?

4. For the example you gave, does the formula in your "current cell" have to actually be =B4 or could it be, as Neil has done, another formula that returns the value from B4 but is clearly a much longer formula?

5. Are you trying to do this with a macro?

6. Would a macro be acceptable?

7. What version of Excel are you using?