Sounds like you want to set the value of an autofilter dropdown using code.

Turn on the macro recorder

select your data and do Data=filter=Autofilter
select the dropdown in your column of interest, and click the down arrow.
Select the value you want to filter on.

Turn off the macro recorder.

Now you can just modify the recorded code to pick up the value for the
Criteria1 assignment from you cell and you can trigger this is the Change
events.

for information on events, see Chip Pearson's site
http://www.cpearson.com/excel/events.htm

--
Regards,
Tom Ogilvy


"kevink79" wrote:


I have a template with some columns as attachment

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

Appreciate your help with given formulas.

Many Thanks


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

--
kevink79
------------------------------------------------------------------------
kevink79's Profile: http://www.excelforum.com/member.php...o&userid=28200
View this thread: http://www.excelforum.com/showthread...hreadid=527478