I have a worksheet in which the cell in column B of the membership list contains a 'Y' or a 'N', depending on whether someone is a member or not.

I want to write a macro, whereby, on clicking the macro button, only rows with a 'Y' will show. Rows with a 'N' will be hidden.

Any help appreciated.