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