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.

	A	B	C	D	E	F	G
1		Folder Base Name	File base Name				Base Path
2		VO	Variation				H:\Test
3
4	Number	Folder	File	Cell	Link Nickname		Hyperlink <tbody> </tbody>
5	1	=B$2&$A5	=C$2&$A5	D5	Linkto1		=HYPERLINK("["&$G$2&$B5&"\"&C$5&".xlsx]"&D5&"",E5)
6	2	=B$2&$A6	=C$2&$A6	B5	Linkto2		=HYPERLINK("["&$G$2&$B6&"\"&C$5&".xlsx]"&D6&"",E6)
7	3	=B$2&$A7	=C$2&$A7	C6	Linkto3		=HYPERLINK("["&$G$2&$B7&"\"&C$5&".xlsx]"&D7&"",E7)

<tbody>
</tbody>