Dynamic Hyperlinks

Hi all,

I have a dropdown list and want to add a hypelink to an array in within the workbook. So when a user selects a value from the dropdown that value is hypelinked to a reference within the workbook. However, the problem is hypelinks are specific to cells and not values.

Can anyone suggest a way round this problem? I considered using the HYPERLINK function for this purpose, but I think this is only used for URL references.

Any help is much appreciated

Thanks,

Anar

Hi,

Could you upload a zipped copy of your workbook, for better visualisation ...

Carim