Search multiple terms through excel

[rich80]

Hi,

I've got a spreadsheet of all of the products that we stock, along with the different prices that we charge. In order to help our new staff to search for the right product, I've put together a front sheet which allows you to search, and then returns those items which match. This is done via VB, but the actual search is just using the standard Excel search function.

What I want to do is allow the user to type in multiple search terms into one box, and just return results that match that criteria.

eg If they are looking for product type A from manufacturer B, I want them to be able to type in "A B" and return the relevant lines that have that info in. At the moment it will only return a line that contains the string "A B".

I've attached a sample of the spreadsheet, so you can see what's happening. (It's only sample data - there are thousands more lines).

The code is a bit long winded because I have had to write multiple sections dependant on which column the data is found. Data is held on DATA sheet - hidden (& workbook protected but I've removed passwords).

Let me know if you have any ideas on this.

[rylo]

Hi

One way would be to have a nominated delimiter and you could then split out the various items, and loop the search for all the items. I don't think it could be a space, as this may be part of a valid search string.


rylo

[fron]

hi,

I suggest you to use autofilter and search from multiple textbox. User can simply put from various textbox and search from multiple options.