Hi Gents,

I'm stumped with this one, I'm trying to replace the existing formula based text search so it functions exactly the same as it does now on the attached sheet, but with a macro which will allow the user to search for multiple values (words) but without the necessity to type the exact text string.

For example, currently to find "Mapress Copper Couplings" you must type "Mapress Copper Couplings" into cell D3 in the "Search" tab and it will bring up all the coupling sizes from 15-108mm, what I would like to be able to do is type any combination of those words and still find the same group of results, even better would be parts of words i.e coupling instead of couplings.

The search term(s) is entered into cell D3 in the "Search" tab, the macro searches column C on the "Products" tab and then shows the 25 most relevant results (in order of relevance) in cells D6-D30 back in the "Search" tab.

You might ask why the current search is inadequate, but the database will eventually have several thousand lines and learning the exact descriptions for each item will be next to impossible, for me anyway , so this will hopefully make populating the table of items much more efficient and more user friendly for others.

Thanks in advance,

Adam

Quote Builder test.xlsm