Dear all,

I'm new here. However i need some advanced function in Excel:
I have a hyperlink cell with the follow example/information:
='H:\Projects\PRO180045.Try\Documents\[Board projectcard.xlsx]Template'!$A$2

This shown me the directory pad: H:\Projects\PRO180045.Try\Documents\
The data in the document: [Board projectcard.xlsx]Template'!$A$2

For example the data in: ='H:\Projects\PRO180045.Try\Documents\[Board projectcard.xlsx]Template'!$A$2 gives me return: PRO180045.
I need this for multiple projects: Only PRO180045.Try changes. For example to: PRO180046.Yes

I can split the hyperlink: set PRO180045.Try in a separate cell, and concatenate the hyperlink again.
However after this excel display not the data in a cell.

So in general i need the information in:
='H:\Projects\PRO180045.Try\Documents\[Board projectcard.xlsx]Template'!$A$2
='H:\Projects\PRO180046.Yes\Documents\[Board projectcard.xlsx]Template'!$A$2

I want to build up the hyperlink from multiple cells. After this i want to display the information from the source.

Thanks in advance!
Firegun