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.