To OP

As an alternative to Don's macro suggestion............

To use an advanced filter with results to another sheet see Debra's site.

http://www.contextures.on.ca/xladvfi...html#ExtractWs


Gord Dibben MS Excel MVP

On Sun, 3 Apr 2011 06:03:25 -0700 (PDT), Donald Guillett
wrote:

On Apr 2, 8:55*am, Johnnyboy5 wrote:
I have a very small table of 22 questions which only require YES NO
replies in one column.

How to I either make a pivot table report to just show the YES.

Or set up an advanced filter to a new sheet which just shows yes
results

or is there a better way ?

Thanks

John

Why not a simple one click macro to
datafilterautofilterfilter by yescopy to other sheetunfilter