Dynamic Hyperlinking!

Hi Gareth,

Thank you for your question.

I have come up with a possible solution which I will outline below:

=HYPERLINK(CONCATENATE("C:\",D1,".xls"),D1)

This function will combine the location of the file with the value specified in the cell and file type and finally the value from the cell displayed as the hyperlink name.

As you are trying to link the client code with the filename, the client code cannot contain a / or a \ as excel files cannot be saved with a / or \ in the filename.

In a blank cell next to the client number, enter the formula above but change the cell reference and filename as appropriate. Copy and paste the formula where appropriate.

I hope this answers your question.

Regards

Simon