Filtering using a text string and displaying values using VB

[tvmex_210]

Hello Xperts,

I have values in 4 columns: NAME, ADDRESS , COMPANY, LOCATION. Now i want to filter in each column by typing in a specific text string. So a cell just below the column header and above the values where i can type in the keyword and when i Enter the filtered results shall be displayed. Also it should be possible to filter in multiple columns.

Is there any codes to do this?? Please help me......

Thanks in advance.....

 

[Silvrhelm]

This link has the informaion that you need

http://www.contextures.com/xladvfilter01.html

Hope this helps