automatic hyperlink

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top