hello there
My question may seem dumb
I want ot know if it's possible to store the link to a value in a closed workbook in a cell and use it to obtain the value
I'll explain let's say my value is in the workbook called "Scenario.xlsm" and its reference inside a link would 'C\Master\[Scenario.xlsm]Parameters'!$B$9
if i do the following command = 'C\Master\[Scenario.xlsm]Parameters'!$B$9 excel gives me the value in B9
But is it possible to store this link inside a cell let's call it B3
and when i use the formula = B3 it will not give me the text adress but instead the value which this adress references
I hope i'm not too vague
Thnaks in advance
My question may seem dumb
I want ot know if it's possible to store the link to a value in a closed workbook in a cell and use it to obtain the value
I'll explain let's say my value is in the workbook called "Scenario.xlsm" and its reference inside a link would 'C\Master\[Scenario.xlsm]Parameters'!$B$9
if i do the following command = 'C\Master\[Scenario.xlsm]Parameters'!$B$9 excel gives me the value in B9
But is it possible to store this link inside a cell let's call it B3
and when i use the formula = B3 it will not give me the text adress but instead the value which this adress references
I hope i'm not too vague
Thnaks in advance