Forum Discussion
How to get the link to show the text in referenced cell
So I have an index that links to other sheets. But it will name the link '1'. I am not sure what i need to do, so that the hyperlink simply copies the text in a specific cell, which in this case will...
Hi,
It would be good if you share the excel file.
Secondly, using If() function a link can be changed if the referenced text changes.
Thanks,
Tauqeer
tauqeeracma I cant share the file itself, but I made a simplified version (that doesnt have any real info) of what I am essentially trying to do...
Youll see on the index page, that I have a room number in the first column, and a hyperlink in the second. I am trying to get the hyperlink text to be the same as the text on the linked cell (and should it change, auto update), without having to manually write each one.
Do you think that is possible? Thanks for the help!
- Yes, it is possible to auto update the name of hyper link. Please attach your simplified version , I will explain. Thanks, Tauqeer
tauqeeracma woops, forgot to attach last time...
- Hi, Please see the attached file, now all your hyperlinks are linked to the names and will automatically update in case these names are changed. Thanks Tauqeer