I have one worksheet of all the people invited to an event. One column
indicates y for they're coming, n for they're not and blank if they have not
yet replied.

I want to set up a separate worksheet that lists *only* the acceptances. In
other words, I want a separate worksheet that extracts the rows of data that
contain y in column B but none of the other rows.

Any advice?
Madeline in Toronto