First post - so hello one and all.
I am stuck with using a user input search term in a cell, and finding variants of this string.
Cell Entry Example: Professional Land Fees
I want to then find all cells that contain all of those words in all orders (eg Professional Land Fees / Land Professional Fees / Fees Land Professional / Land Fees Professional) - I am able to search and then carry out actions when the string is found in the order of user entry, I am struggling with coding it to look for all variants.
Any help very much appreciated.
Thank you in Advance.