M
Mike
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.
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.