Dynamic excel hyperlink

[Ebramluis]

I have
Source.Xlsx
Contains employee details
Empcode empname empage

1001 mark 35
1002 Peter 40
1003 William 27

And for each employee I have a sheet named with empcode
1001.xlsx
1002.xlsx
1003.xlsx


I make a hyperlink of the Empcode at source. Xlsx
And I want to make the direction on it dynamic depends on the Empcode

If I press on 1002 at the source. Xlsx at the Empcode column the link go to 1002.xlsx etc

Thank you for advance

 

[Toadstool]

Hi Ebramluis,

Depending how your directory is structured you may need to provide the explicit directory.

e.g. 1001.xlsx is in my current directory so works just by adding ".xlsx". 1002 is in a sub-directory so I need to add that.

Source.xlsx
	A	B	C	D
1	Empcode	Name	Age	Link
2	1001	mark	35	1001
3	1002	Peter	40	1002
4	1003	William	27	1003
Sheet1

Cell Formulas
Range	Formula
D2,D4	D2	=HYPERLINK(A2&".xlsx",A2)
D3	D3	=HYPERLINK("C:\MrExcel\Ebramluis\"&A3&".xlsx",A3)