Search Facility

[anar_baku]

Hi guys,

I have a big database in the following format:

Header 1 Header 2 Header 3
------------ ------------ ------------
Value 1.1 Value1.2 Value1.3
Value 2.1 Value2.2 Value2.3
Value 3.1 Value3.2 Value3.3
Value 4.1 Value4.2 Value4.3
etc...

As the database is quite big I want to create a search facility for
anyone who uses the database to find what they want quicker. I want to
refrain from using manual Ctrl + F facility. So what I want to do is
store the database in Sheet 2 and have a search page on Sheet 1 that
takes a keyword from the user (say in Cell A2) and uses it to search
the database once the user hits the Search button. If, for example, the
user enters a keyword that matches the citeria in rows 3 and 4 above
then it returns the following on Sheet 1, just under the search
facility:

Header 1 Header 2 Header 3
------------ ------------ ------------
Value 3.1 Value3.2 Value3.3
Value 4.1 Value4.2 Value4.3

I'm struggling to find a solution and would appreciate if someone could
put me in the right direction or better even suggest a coding! I've
tried to search for existing postings on the forum, but couldn't find
anything that would help me. Maybe I didn't search for the right
stuff.

Please help.

Thanks in advance

 

[anar_baku]

I still haven't found any good solutions to this problem so woul
appreciate if someone could shed a light

 

[Tom Ogilvy]

Perhaps you want to use the Advanced filter.

 

[anar_baku]

Thanks a lot, this was very helpful! Hadn't ever used Advanced Filter
before