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
Bookmarks