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
| Attachment | Size |
|---|---|
| Example 1.xlsx | 10.78 KB |
- CharlieTrey's blog
- Login or register to post comments
- 5894 reads
the best way to do this is
the best way to do this is with some VBA, so that when you double click on the cell, it takes you to the next one
There's an example here: excelexperts.com/VBA-Tips-Double-Click
to modify it for your needs, change the "myDoubleClickmacro" to be something like this:
sub myDoubleClickMacro()
set rngFoundIt = workbooks("xxxx").sheets("YYYY").find(selection.value)
if not rngFoundIt is nothing then
workbooks("xxxx").activate
sheets("YYYY").select
rngFoundIt.select endif
end sub
- where xxxx is the source workbook, and yyyy is the source sheet