Is there a way to link a specific keyword from one workbook to another? I know it is possible to link from the cell reference, but I am looking to link from the data within the cell instead.
My reasoning to link to the words/data/information is because right now I have a huge source workbook with a lot of links in there. If I want to insert/delete rows it completely changes all of the other links when I don't want it to.
Attached is my example worksheet. Is there a way that I can link to the word STACY, so that anywhere it says STACY it will automatically link to my destination workbook? (and hopefully keep all of the other information (age, group) and link that as well?)). I don't want to have to link to "A1".
If this is not achievable, is there a method so that if I insert/delete rows in my source workbook it won't completely affect all of my other links that I have set up?
PLEASE HELP![]()
Bookmarks