Hyperlink and changing file name

[Martinbif]

Hi i am trying to use a hyperlink formula where i want to return a number from another sheet and create hyperlink to that number.

I have used:

=HYPERLINK("[Martin_0.xlsx]UW!D4"; UW!D4)

Which gives me the correct value and creates the link. But if i change the file version to _1 or _2 the link doesnt work. What can i do to make the file name dynamic?

Thanks

Br

Martin

[JBeaucaire]

You would need to possibly put the file name in another cell and refer to that in your formula, for instance D1 on that same sheet:


=HYPERLINK("[" & UW!D1 & "]UW!D4"; UW!D4)

[Martinbif]

Ok cool

But how to i "call" the file name in D1 then? It changes when i do a save as?

Thanks

[JBeaucaire]

You would need to change it in that cell as well.