+ Reply to Thread
Results 1 to 1 of 1

Linking Specific Keyword/Data (NOT CELL REFERENCE) to Another Workbook

Hybrid View

  1. #1
    Registered User
    Join Date
    04-11-2013
    Location
    Chicago, Illinois
    MS-Off Ver
    Excel 2010
    Posts
    1

    Linking Specific Keyword/Data (NOT CELL REFERENCE) to Another Workbook

    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
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1