VB to filter words contained in range

[Trevor3007]

HI,

Rather than manually create a filter & select the ones 'I dont need ' is it possible to have VB to do this , using a words contained in another worksheet in the same work book? For example

The data to be filtered is in(Source) a2:a150, I want the 'filter' to filter the words that are NOT in the range (filter) Column A
As I often have to run this , it would be quicker to just add the ones I don't want into (filter) Column A, rather than redo the filter each time.

Hoping this makes sense & thanks to the person(s) who like a challenge.

 

[Trebor76]

Thanks Peter

 

[Trevor3007]

=SORT(FILTER(A2:A150,ISNUMBER(MATCH(A2:A150,filter!A:A,0)),""))

Many thanks for your help. Much appreciated.