lady_alina
Board Regular
- Joined
- Feb 18, 2015
- Messages
- 52
Hi,
Thanks in advance. This site has always been so helpful and I expect to get an answer for this problem as well.
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
<tbody>
</tbody>
Sheet2
<tbody>
</tbody>
Sheet3
<tbody>
</tbody>
Thanks in advance. This site has always been so helpful and I expect to get an answer for this problem as well.
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 |
<tbody>
</tbody>
Sheet2
Alina |
Peter |
George |
Alina |
Mike |
<tbody>
</tbody>
Sheet3
Column A |
theg |
uhwt |
teh alina wer |
<tbody>
</tbody>