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

"Tony123" <(E-Mail Removed)> wrote in message
news:E723D985-388B-476B-8DB8-(E-Mail Removed)...
> 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.
>