I am trying to construct a dynamic link based upon the concatenation of variables contained in other cells.
A1="AHU RTU4.xlsx"
A2="//sharepoint/support/Arizona/2016"
The concatenation would look like the following:
=concatenate(a2,"[",a1,"]Table'!$B$2")
This is where it becomes tricky. How do I automatically extract the information from this location without having to use the hyperlink function since this is a manual step?
Thank you all in advance.
A1="AHU RTU4.xlsx"
A2="//sharepoint/support/Arizona/2016"
The concatenation would look like the following:
=concatenate(a2,"[",a1,"]Table'!$B$2")
This is where it becomes tricky. How do I automatically extract the information from this location without having to use the hyperlink function since this is a manual step?
Thank you all in advance.