How to get the link to show the text in referenced cell

[mbartolucci]

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 always be in cell A1, which would say something like "dining room" or "Bedroom" (or something along those lines). Any help with a lot of explanation would be helpful.. Also, if it is possible, can the link change if the referenced text changs?

Thanks!

[#2]

@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

[#3]

@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

[#4]

@mbartolucci 

Hi

It looks there is a problem today attaching files...

I could only see your file but not modify it. So, I took the time to recreate it for you  and it's working fine.

You can download it from my amazon drive

https://www.amazon.ca/clouddrive/share/UrvmzxCLzIOWwUvodpuBsOuCmEY8tjSsjGgnZCLRIn2

Hope that Helps

Nabil Mourad

[#5]

@mbartolucci 

Hi

If your are satisfied with my solution please mark it as an accepted response

Thanks

Nabil Mourad