filter of data of one column through multiple criteria

Hi friends,

I want to filter the data of column 6 using five criteria say as
1.pass
2.fail
3.compartment
4.X
5. y
how can i achieve that using macro?

one simple approach can be entering

IF(OR(F1="pass",F1="fail",F1="compartment",F1="x",F1="y"),TRUE,FALSE

in the adjacent column and filter for true

rgds

johnjohns