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's obvious you have a problem with the position of the Single quotation and the double quotations.
Also tell me what do you have in Cell A1, Cell A2 and in which cell you write the formula?
You need to follow this pattern.
If I had a file I would do it for you (or look at my tutorial for this part)
Nabil Mourad
nabilmourad I posted a basic excel file of what I am essentially trying to do. So on my index page Column B is where I want to attach the link (with friendly name) to cell A1 from every page except the index (which contains a room name in that cell).