Autofilter based on a drop down box on another sheet in a work book.

I have a data validation drop down box in cell D199 on my first sheet (Raw Material Creation Template), I want the user to be able to select a valid value from this list and have column B on my second spreadsheet (Material Characteristics) automatically filter. Both sheets are locked and if the value is cleared out on the first sheet, I need the filter to clear as well. I have never written a Macro and am new to more advanced functions in Excel and could use a little help with the correct coding or another way of achieving the same results?

Thanks for any help!

I was able to find someone to help me, used a =Criteria & =If formulas and then the following macro:

Range("D199").Select
Worksheets("Material Characteristics").Unprotect Password:="Password"
Sheets("Material Characteristics").Select
Range("C2").Select
ActiveSheet.Range("$A$1:$F$308").Autofilter Field:=3, Criteria1:="1"
Sheets("Material Characteristics").Select
Worksheets("Material Characteristics").Protect Password:="Password", DrawingObjects:=True, Contents:=True, Scenarios:=True _
, AllowFiltering:=False

Not quite what I wanted, but it works.