So I have a link to a different workbook using an absolute reference:
But i want to split this link up into different parts to make it more easily changeable. I want to pull the data used in the link from different cells, concatenate it, and create a link. So cell A1 would contain:
B1:
C1:
D1:
And then E1:
This creates a string with the exact text contained in the original link, but it is just that; a string. How do I convert this string to a live link?
Code:
='C:\Users\Pete\Documents\Timesheets\[51.Davies, TimeKeeping.xlsx]Times'!$B$42
But i want to split this link up into different parts to make it more easily changeable. I want to pull the data used in the link from different cells, concatenate it, and create a link. So cell A1 would contain:
Code:
'C:\Users\Pete\Documents\Timesheets\[
B1:
Code:
51.Davies
C1:
Code:
TimeKeeping.xlsx]
D1:
Code:
Times'!$B$42
And then E1:
Code:
=concatenate(A1,B1,C1,D1)
This creates a string with the exact text contained in the original link, but it is just that; a string. How do I convert this string to a live link?