automatic hyperlink

[Tony123]

Hi Guys,

I am wondering if it would be possible to automatically hyperlink from one
excel sheet to another.

Let me explain.

In cell C7 there is a reference number like 500685698 (this is unique). When
I enter something in cell M7 I would like C7 to automatically hyperlink to an
excel sheet (saved as 500685698) in another folder.

If this is possible, it would save me a lot of time every day. Your help is
always appreciated.

 

[NickHK]

Whilst you can use .Find/hyperlink/set a formula to a values on another
sheet, how is Excel/VBA supposed to know which folder and which workbook it
should use ?

NickHK