Enhance wordlist through synonyms in Col.D

Hello every one,

I have to enhance the number of words in column A through the synonyms from column D.

i have an excel worksheet containing a wordlist:

Column A contains Words(language A)
Column B contains transcription
Column C contains grammatic information of the words
Column D contains Meanings( language B);µ synonyms(of word in Column A also in language A)[seperator between Menaings and Synonyms is ";µ" and seperator between different Meanings and between differen Synonyms is ";"]


For example:

Col.A(Germen words)---------Col.B--------------Col.C---------------------Col.D(English Meanings ;µ German synonyms)
lieben------------------------ lieban --------------- v.-----------------------to love;to affect;µmögen;seks haben;etwas möchten
seks haben----------------------lieban-----------------v.-----------------------to love


Now a macro is needed which reads the synonyms in column D which follow the meanings after ";µ". After reading the synonyms the macro should look if theses words also exist in column A as words or not. If a synonym doesnt exist in Column A then new entries should be made at the end of the wordlist. That sysnonym should be added as new entry to colulmn A. According to our example it should later look like;



After running the macro:

Col.A(Germen words)---------Col.B--------------Col.C---------------------Col.D(English Meanings ;µ German synonyms)
lieben------------------------- lieban --------------- v.-----------------------to love;to affect;µmögen; seks haben;etwas möchten
seks haben---------------------lieban-----------------v.-----------------------to love
mögen-------------------------(empty)-------------v.(from original word)----to -love; to affect;µ seks haben;etwas möchten;lieben
etwas möchten---------------(empty)-------------v.(from original word)----to love; to affect;µ mögen;seks haben;lieben


The last two entries in the example are made by the macro. Only those synonmys are choses which didnt already exist in coulmn A. And the meanings synonyms are taken from the original entry. The new entry doesnt exist it self in column D as synonym.

I will be very thankful if some one could help me solve this.

Thanks in advance

Here is the example as excel file