copy cells from one sheet to another if...

[wali]

Hello every one,

I need help in processing a very large data. I will be very thankful if someone could help me with it.

i have two worksheets:
first one is: "ws1" containing of col.A(140 000 cells) and col. F
second one is: "ws2" containing of col. A(109 000 cells) and col. B

I want to copy content of col. B from ws2 to col. F ws1, if col.A ws1 exists as part of string in col.A ws2. If there are more than one matches then only the first 10 results should be copied and sperated by ";;" in col.F ws1. After one search is finished then the search should be continued from last position and not from start. There should be no duplicates in col.F.

for example:

ws1 before:
col.A(contain of words and compunds)
back
backer
backwards

ws2
col.A(very long text)...............col.B(long text)
dkd backen...............................m1
fdlkbackisl.................................m2
asdbacker adsl...........................m3
backwards slsbacker...................m3
backerlsl sls so...........................m4

ws1 after:
col.A...................................col.F
back...................................m1;m2;m3;m4
backer................................m3;m4
backwards...........................m3


Thanks for each help in advance.