Hi All,

Hopefully you can help.

I currently have formula that are linked to other worksheets within my workbook and I want to be able to get some secondary information from that formula.

So for example i currently have a formula which is linked to a specific cell in another sheet

='P01'$K$45

This is in cell F57

What I would like to do is have cell I45 reference the above formula but change the letter to $J$45.

Is this possible?

TIA

Sam