data search vba

wheellp

New Member
Joined
Aug 2, 2016
Messages
21
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?
 

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,402
Firstly, why isn't simply filtering on category a solution for this?
 

wheellp

New Member
Joined
Aug 2, 2016
Messages
21
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

Well-known Member
Joined
Jul 8, 2002
Messages
11,402
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.

1580070401891.png
 

Watch MrExcel Video

Forum statistics

Threads
1,099,473
Messages
5,468,829
Members
406,612
Latest member
pedad

This Week's Hot Topics

Top