automatic filtering when ENTER is used

[ice]

In the attached file I have a list that can be filtered. I can filter in a couple of different ways.

1. I can input 3 variables into cells C1,D1 & E1 and hit macro filter -3 based
2. or I can input 1 variable and filter. ex. C1 input "Alan" and filter on box just below C1.

What I would like is a macro of some sort that when I enter a value into C1 it automatically filters

same situation if I was to input into D1 & E1.

Based on info on spreadsheet

I enter "Alan" into C1. Filter will give 6 results
enter "AP" into D1. Filtered list will reduce to 3 results.
enter "NO" into E1. Filtered list will reduce to 2 results.


This way I will not have to use the text boxes for filtering at all. Which is helpful for laptop users when a mouse isn't used.