filtering rows based on a cell input

[psyCohn]

I have a file with 2 worksheets. The first one is for entering certain employee fields, and the 2nd worksheet shows all current employees. One of the input fields in the first sheet is for a JOB_CODE number. Is it possible to link that to the 2nd sheet where as soon as I enter that JOB_CODE, the 2nd tab will filter the rows such that they only show the rows for the employees with that same JOB_CODE? The Advanced option in the Filter won't do this. Thanks for the help...

 

[Fluff]

How about

Private Sub Worksheet_change(ByVal Target As Range)

Application.EnableEvents = False
   If Target.CountLarge > 1 Then Exit Sub
   If Target.Column = 2 Then
      Sheets("Sheet2").Range("A1").AutoFilter 2, Target.Value
   End If
Application.EnableEvents = True

End Sub

This needs to go in the sheet module where you enter the data.
As you haven't given us much info It works whenever you enter data in col B & will filter sheet2 col B