Hey all - your favorite person lol.

I am wanting to delete all rows where a specific text is NOT contained in Column K. I have nearly 10,000 lines so whatever the most efficient way to do this would be preferred.

I want to work this out before I take it to the next step which will be to have a check box for first run, that when it is run the first time it asks the user their name and then saves that as the string to use for the above delete rows not containing text.
I will probably make a data list of Names (It's for sales reps here) so that it can be edited if people are lost from the company, that on first run the list pops up and has you check your name in the list or something..but that's not required at first.
I will work that out after (unless someone is really bored LOL)

Thanks in advance as always! This place is always so helpful