Hi there,

I am currently attempting to create Hyperlinks to a specific location/file which is often up-issued..... For example in my T drive under a certain folder name I have file names in the format 1111-1 moving 1111-2 and so on.

when they are amended or up-issued they get a character added such as 1111-1A then 1111-1B

I can get the hyperlink to find the numeric value and open it. I can even add another cell which finds the character specific up-issue but that currently is where im stuck.

The character issue has to be entered manually when you know the issue. I would like it to locate the highest value between a-z external to excel and open that.

Or such as a formula which does not find the highest value but represents the highest value.

Any help would be appreciated

Thanks