Hi,

Thanks in advance. I am new in this forum and new to VBA also. Hope to get an answer from here. i know what I'm trying is tricky and I searched the internet but couldn't find the answer. I would really appreciate if you experts could solve my problem.

I have given below table to show you example, what I want is set of strings in column B (sheet 1) should match its words with sheet 2 column a and sheet 3 column a if any word is found in sheet 2 column a which is also found in sheet 3 column a then that word should be excluded from the out put like for examples you can check the first column of sheet 1 column C - ideally it should have copied alina, tim but since alina is found in sheet 3 column a it is excluded from the output and only tim is copied. Hop eI made myself clear. Please help me with a vba code to simplify my work.


Sheet 1
Column A Column B Column C
1 ABC THY Alina tim tomorrow tim
2 WERT 00 PETER TIM Peter
3 GYT GEORGE ALINA GNEH George, Alina
4 PWO0 MIKE KLERW Mike

In above table if you see the first output is tim instead of alina and tim because the words which are found in sheet 3 should be excluded from the output.


Sheet2
Alina
Peter
George
Alina
Mike



Sheet3
Column A
theg
uhwt
teh alina wer