Hi! I am trying to create a formula that will seach a specific column for a
certain word within a text string and if the word is present to copy the row
and paste it in a new worksheet. Any ideas?

I need to search Column E for the word "enterprise" and if found I need to
copy the entire row and its data into a new worksheet. Currently have 33919
rows to check, any help would be greatly appreciated!

Thanks!