External links

[Alan Duffell]

I have a number of folders named: VO1, VO2, VO3, Each contain a workbook named; Variation 1,Variation 2, Variation 3 respectively.
I need to link cells within each workbook to another workbook named: Register and need a formula I can fill down column to read a number from a cell and use as part of the folder and file names.

Hope someone can help.
Alan

 

[matttclark]

Alan,

Not sure from your message if this is what you want, but maybe it'll get you on your way.



[TABLE="class: grid, width: 800"]
<tbody>[TR]
[TD][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Folder Base Name[/TD]
[TD="align: center"]File base Name[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD][/TD]
[TD="align: center"]Base Path[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD="align: center"][/TD]
[TD="align: center"]VO[/TD]
[TD="align: center"]Variation[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD][/TD]
[TD]H:\Test[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD="align: center"]Number[/TD]
[TD="align: center"]Folder[/TD]
[TD="align: center"]File[/TD]
[TD="align: center"]Cell[/TD]
[TD="align: center"]Link Nickname[/TD]
[TD][/TD]
[TD]

<tbody>
[TD="align: center"]Hyperlink[/TD]

</tbody>

[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]=B$2&$A5[/TD]
[TD="align: center"]=C$2&$A5[/TD]
[TD="align: center"]D5[/TD]
[TD="align: center"]Linkto1[/TD]
[TD][/TD]
[TD]=HYPERLINK("["&$G$2&$B5&"\"&C$5&".xlsx]"&D5&"",E5)[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]=B$2&$A6[/TD]
[TD="align: center"]=C$2&$A6[/TD]
[TD="align: center"]B5[/TD]
[TD="align: center"]Linkto2[/TD]
[TD][/TD]
[TD]=HYPERLINK("["&$G$2&$B6&"\"&C$5&".xlsx]"&D6&"",E6)[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]=B$2&$A7[/TD]
[TD="align: center"]=C$2&$A7[/TD]
[TD="align: center"]C6[/TD]
[TD="align: center"]Linkto3[/TD]
[TD][/TD]
[TD]=HYPERLINK("["&$G$2&$B7&"\"&C$5&".xlsx]"&D7&"",E7)[/TD]
[/TR]
</tbody>[/TABLE]