Forum Discussion

mbartolucci's avatar
mbartolucci
Copper Contributor
Jul 29, 2019

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...
excel
mbartolucci's avatar
mbartolucci
Copper Contributor
Jul 31, 2019

nabilmourad Oh I think I understand the problem. It is linking to the cell beside it correct?

So in the file, under 'index', i have a room number which corresponds with a tab. so for example, in the index, I want to have the cell beside room number 0004 (under Room Name column, B) to link to tab 0004, and to name itself with whatever is written in cell A1 of sheet 0004. Perhaps thats what you are already saying and I simply dont understand..

  • mbartolucci's avatar
    mbartolucci
    Copper Contributor
    Jul 31, 2019

    nabilmourad Since I cant seem to attach the file, here is a one drive link to the file instead

    https://1drv.ms/x/s!Ap5GfAPWJw6r2V5WgF57CH34LU1z?e=jflxpd

  • mbartolucci's avatar
    mbartolucci
    Copper Contributor
    Jul 31, 2019

    nabilmourad No it doesnt work... i am sure I am doing something wrong. It will not show the cell name, nor actually link to it.  I am trying to attach a different version but thats having trouble too. I guess its not my day with computer stuff

Resources