ExcelBanter - Search Facility

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
------------------------------------------------------------------------
anar_baku's Profile: http://www.excelforum.com/member.php...o&userid=18259
View this thread: http://www.excelforum.com/showthread...hreadid=397724