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

Please Login or Register  to view this content.

in the adjacent column and filter for true

rgds

johnjohns