Auto Filtering Macro that Filters for more than one item

I have a macro that auto sorts one worksheet and copies the filtered data to another.

What I need is for when my macro asks for input on what department to filter I need it to look for the one they list plus another.

Example: There is a department called QA and QC. When they type in QC I need the macro to filter for QC & QA. I need this to work both ways.

Here is part of my code

Formula:

Please Login or Register  to view this content.

Thanks for the help