This is a relatively simple question but very hard to explain and therefore 'google', so I thought I'd ask here!
Cells J6:209 are filled with already established references to other sheets. Each cell references a different sheet:
J6: ='[Sheet2 - 7th May 2018 - Budget.xlsx]Summary'!$C$26
I want to use a formula in K6 that will return [Sheet2 - 7h May 2018 - Budget.xlsx]Summary'!$E$26 but this is proving very difficult to do without opening every individual sheet and manually inputting it.
Is there a way to extract the reference from J6 and add it to K6 but changing the $C to a $E without actually opening Sheet2?
Thanks
Cells J6:209 are filled with already established references to other sheets. Each cell references a different sheet:
J6: ='[Sheet2 - 7th May 2018 - Budget.xlsx]Summary'!$C$26
I want to use a formula in K6 that will return [Sheet2 - 7h May 2018 - Budget.xlsx]Summary'!$E$26 but this is proving very difficult to do without opening every individual sheet and manually inputting it.
Is there a way to extract the reference from J6 and add it to K6 but changing the $C to a $E without actually opening Sheet2?
Thanks
