Auto Filter depending on Cell Value

Dear rizvisa1,

Thank you to your prompt reply.

I don't know what you mean by your answer "Use sheet change event to update the filter", how it works?.
I think I need VBA code to do my request? can you provide me with this code.

Thank you again for any kind assistance.

Issa

Yes you need VBA
1. Open the file
2. Press ALT + F11
3. Press CTRL + R
4. Double click on the sheet where you want this functionality
5. Paste the code

Private Sub Worksheet_Change(ByVal Target As Range) 
   If (Intersect(Target, Range("E1")) Is Nothing) _ 
   Then 
      Exit Sub 
   End If 
   Cells.AutoFilter Field:=1, Criteria1:="=" & Range("E1") 
End Sub

This is based on assumption that you want to filter the 1st column (column A). Change value of "Field" to point to right column

By the way you can use wild card in E1 like
1234* ( some thing that starts with 1234)
123?56??? (some thing that start with 123, then has some character, followed by 56 followed by three charachters
*1234* (some thing that has 1234 some where)