Finding a word string in a column of ~160,000 rows

Hello all,
I have a data dump which contains column containing sentences and word fragments.

Is there a way, using VBA, which will allow me to search this data and return the items found in another sheet as a distinct set of sentences?
So for example:

row Column B
2 She said this
3 He wasnt available
4 Lucy was involved and available.

It would be great if the macro would prompt the user to enter the word string they are interested in and then return the results in another page.
So entering Lucy would return row 4 only.
And entering Lucy and available would provide row 3 and 4.

Thanks so much for your help
Lucy

Hi Arkadi, via a message box, so you would be invited to enter a string and it would use that in the search.
Thank you!

yes, but its slow considering the volume of rows
hence my request for help with a vba option - thanks!
Lucy

I think it will be slow, but will be surprised if you find anything quicker

hello everyone, is this possible using VBA? sorry to ask again.

Thank for any help.

hi , see attached file. For example you would search the text for words like "brain". And it would return the results to the Results worksheet together with the numbers from col2, col3 and total.

thank you again.

Hi ,thanks for your reply

It doesnt seem to be working however, if I type in Ablation for example it gives me row numbers which dont contain ablation.
Infact it always gives the same numbers.

Also, would it be possible for the results to be saved in the "Results" sheet, so a copy of each row in the Data sheet which contains a word or string of words entered in the message box.

Hope that is ok.
Thanks very much.
Lucy

thank you both, this is great !