VB macro to delete row if one column does not have string

[MarkinhusZN]

Hello All,
I've been breaking my head to solve an issue with powershell, and figured excel would've been the easier way.

I need a vb macro that would look at Column B, it would go through all 2900 records in Column B and compared it to a Text File I have of 591 users. If the value in Column B does not equal to the value I have on Text file then delete the row.
I have tried some macros around but they usually only work with a single string and since I am not savy with vb code, I do not know how to make it read from file. I can also post the strings on the vb macro but it always give syntax error. Please save me lol.
I appreciate all the help

 

[MarkinhusZN]

bump?

 

[Akuini]

The text file content is a list of words, right?
Can you manually copy and paste the list into a worksheet? Say, to sheet2 col A.
If yes, I think I can write a macro to do the job.