data search vba

[wheellp]

I have a large Q&A spreadsheet with rows that include question, answer, category, sub category, and date updated. I am looking for someone to create a form in which I can search with the option of filtering by category. I am thinking a place to insert the phrase or question (and be able to filter) and below on the left have the matching result and on the right results that might close or relevant to the matching answer. I would also like to be able to add more questions to the database and the form to work with the new information as well. Help?

 

[GlennUK]

Firstly, why isn't simply filtering on category a solution for this?

 

[wheellp]

Firstly, why isn't simply filtering on category a solution for this?

So Each category has 200+ questions in it and we have over 1500 questions and answers and add to it daily. We use this to answer customer questionnaires. So I was hoping we could search the full question and if there is an exact match all of the information would show up on one side and if anything matches to show up on other side. Would save alot of time. If that helps

 

[GlennUK]

How is your VBA? And how many terms max will you allow in your question?

In the following data I used Advanced Filter with the 2 cases of criteria to get the kind of searching you want ... all you need to do is develop it using filtering to another location, and then populating your viewing areas.