Dynamic filter criteria

Hi,

I have a autofilter and it will filter the data in columnB depends on the state users choose. The user can pick state via multi optionbuttoms (NJ, PA, etc.) Each state will refer to the specific number (NJ=2, PA=3, etc). What I try to do is filte the data under columnB that contain 2 (if I pick NJ in this case). here is my code:

Please Login or Register  to view this content.

This code has some porblme when I add the Criteria 2. Could someone help?

Hi Martin, It works!!!!! thanks!!