Search Engine for Excel

[Stefanopolis]

Hello – I am looking for code that can build an advanced text search engine for excel? Specifically, I need a form that allows users to enter multiple text values that are combined by Boolean (e.g., logical AND, OR, NOT). Then, these text entries are searched in a given database, and the rows that contain the matched terms are returned on a separate sheet. Please advize... Thanks in advance! Stefanopolis

 

[lenze]

Hi and welcome to the board
MSQuery, which is really a SQL app.

lenze

 

[Norie]

Stefanopolis

There is Excel built-in functionality to do this - Data>Advanced filter...

You could create a userform that allowed the user to input the values, logic etc and create the required criteria for the filter.

Might be straightforward but that depends on what you want to do/allow the user to do.