Automatic Filtering
 

On Sheet 1 of a woorkbook I will have data that looks as follows:

A B
1 John No
2 Steve No
3 Mary Yes
4 Jill No
5 Bob Yes
6 Mike Yes

This data will continue on for several hundred rows.

On Sheet 2 of the same workbook I want to automatically filter out all of
the No answers and be left with only the Yes answers. The rersult would be as
follows:

A B
1 Mary Yes
2 Bob Yes
3 Mike Yes

What I a trying to get here is a formula or a macro that will simultaneously
filter out the No answers as they are being entered on Sheet 1.

Any help would be appreciated.