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?