Need help in keyword searching

[doms123]

I'm using Excel2007 and I'm doing a database, i have a lots of concerns and questions, let me start with this.

I have two sheets, the first sheet is the search sheet, then the second is the masterlist. I want to have a search button than can actually search for its key word and filtering the others. (This is searching if filtering by its keyword)

This is the Scenario for example my text box for search is Sheet.range(A1).value
and my search button in First Sheet.

then in my Second Sheet i have my database this are the following data

(collumn 1) (collumn2) (collumn3)
(row1) MS-00 Test One A Mark Twain
(row2) MS-01 Test Two B Sherlock Holmes
(row3) MS-02 Test Two A George Bush


if type a value in my Sheet.range(A1).value and click the search button like Holmes then the whole row2 will appear and the other will be filtered or hide


like this...
(collumn 1) (collumn2) (collumn3)
(row2) MS-01 Test Two B Sherlock Holmes


or if type a value in my Sheet.range(A1).value and click the search button like Two then the whole row2 and row3 will appear and the other will be filtered or hide

like this
(collumn 1) (collumn2) (collumn3)
(row2) MS-01 Test Two B Sherlock Holmes
(row3) MS-02 Test Two A George Bush


Please Help!!!
Thank you in advance....
<!-- / message -->

 

[Joe4]

Duplicate: http://www.mrexcel.com/forum/showthread.php?t=544608

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).