I have a template with some columns as attachment

Question is: I would like to have a field, When people type in
valuethen Enter, the program will automatically filter rows whic
column (Applicable Service) is not typed value.

Appreciate your help with given formulas.

Many Thank

+-------------------------------------------------------------------
|Filename: Project Tracking & MA.zip
|Download: http://www.excelforum.com/attachment.php?postid=4540
+-------------------------------------------------------------------

--
kevink7
-----------------------------------------------------------------------
kevink79's Profile: http://www.excelforum.com/member.php...fo&userid=2820
View this thread: http://www.excelforum.com/showthread.php?threadid=52747