I have several rows of cells containing sentences, like 'the dog ra
after the cat). On another sheet, I have a glossary of terms wit
Column A giving the term, and column B the meaning (eg (Col A) Dog (Co
B) Four legged animal that dislikes cats).

I want to identify in each of the cells within the rows, that contai
the sentences, which words (if any) are in the glossary, and the
hyperlink them to one another (the individual words, not the whol
cells), or at the least, underline the words so the reader knows thei
meaning is explained in the glossary.

I think this is a VBA problem but not sure.

Thanks for your help in advance

--
Andrew
-----------------------------------------------------------------------
AndrewB's Profile: http://www.excelforum.com/member.php...fo&userid=3199
View this thread: http://www.excelforum.com/showthread.php?threadid=51726

suppose in sheet 1 in B2 the entry is
the dog ran after the cat
in sheet2 a1 is
<dog
B1 is
<the four leggedanimal which ran after the cat
highlight sheet1 B2 and click data(menu)-text to columns
in step 1 of wizard choose
<demilited
and click next
in step2 of the wizard
tick only <space and no other ticks
and click
finish
the words of your sentence will be distributed from B2 to G2 in sheet1
now in sheet 1and cell B3 type
=VLOOKUP(B2,Sheet2!$A$1:$B$1,2,FALSE)

(in this reference $A1:$B$1 may have the whole gloassary database)
copy B3 to c3 to G3
except against dog (i.e. only C3) all others will be #N/A
that means only dog has a meaning in gloosary and no other words in that
sentence
does it give an idea how to solve your problem or is this the problem?

"AndrewB" wrote in
message ...

I have several rows of cells containing sentences, like 'the dog ran
after the cat). On another sheet, I have a glossary of terms with
Column A giving the term, and column B the meaning (eg (Col A) Dog (Col
B) Four legged animal that dislikes cats).

I want to identify in each of the cells within the rows, that contain
the sentences, which words (if any) are in the glossary, and then
hyperlink them to one another (the individual words, not the whole
cells), or at the least, underline the words so the reader knows their
meaning is explained in the glossary.

I think this is a VBA problem but not sure.

Thanks for your help in advance.


--
AndrewB
------------------------------------------------------------------------
AndrewB's Profile:
http://www.excelforum.com/member.php...o&userid=31994
View this thread: http://www.excelforum.com/showthread...hreadid=517261

Thanks for the reply. It works fine, except for one problem. Some of the
terms in the glossary have more than one word, eg:

Sheet 2 A1: <Dog hunting strategy
Sheet 2 B1: <The Dog tends to hunt in packs, but has a less advanced
stealth capabilities than the Cat

Sheet 1 A1: <The application of the Dog hunting strategy to the Cat is
usually unsuccessfull

The only thing I can think of is to list every combination of words
possible. In reality there are a maximum of 3 words in a glossary term.


Thanks,

Andrew


--
AndrewB
------------------------------------------------------------------------
AndrewB's Profile: http://www.excelforum.com/member.php...o&userid=31994
View this thread: http://www.excelforum.com/showthread...hreadid=517261