Can We Do It In Excel ?

[kevink79]

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
+-------------------------------------------------------------------

 

[Tom Ogilvy]

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