Duplicate Formula within cell referrence

[tiong999]

Hello all,

I have a tiny problem which i couldnt find the answer anywhere.
Im looking formula to duplicate formula within cell reference.

Cell Referrence is C9.
C9=Sales!L305


Now i want to make formula within L3
L3= OFFSET(Sales!L305;0,-2)

Is there a way how to duplicate only formula within cell C9, instead of value of C9?


Hope somone can understand my question, ill be glad for your assistance.


Regards,
Tiong

 

[bosco_yip]

Not sure in understanding your question.

Guessing......

In L3:

=OFFSET(INDIRECT(MID(FORMULATEXT(C9),2,99)),0,-2)

Regards
Bosco

 

[tiong999]

Hello bosco,

Thanks for your formula, but unfortunately i dont have FORMULATEXT function in my excel 2007 version.

Regards,
Tiong

 

[bosco_yip]

FORMULATEXT function was introduced in Excel 2013 and isn't available in Excel 2007.

So your question may need someone helping to provide VBA code.

Regards
Bosco

 

[tiong999]

Thanks for your kindness contribution.

Regards,
Tiong