Well I've found a way that works for me at
http://www.contextures.com/xlautofilter03.html#Copy
Debra's site is awesome! And this forum is great. It seems like you can do
just about anything with an Excel spreadsheet, if you can only figure out
how.
Thanks to everyone who takes the time to help others put all the pieces
together.

To that end, my solution was to use the autofilter. Then use the macro I
found at Contextures to copy the results into a new sheet. The new list is
exactly how I wanted it.

BTW the problem with my Advanced Filter was that, following the examples in
the help pages, I had put my criteria range above my list. After looking
around Contextures, I moved my criteria range to the side, and it worked just
fine.

Thanks again to everyone.

Hi

Had I realised at the outset that you wanted to extract data to another
sheet, I would have suggested Advanced Filter and would have directed
you to Debra Dalgleish's site at Contextures. She has excellent
instruction on all manner of things, including Filtering - as you have
found.

Thank you for posting back and letting us know how you got on, and well
done for your resourcefulness in finding the solution that suited you.


--
Regards

Roger Govier


"tabbicat" wrote in message
...
Well I've found a way that works for me at
http://www.contextures.com/xlautofilter03.html#Copy
Debra's site is awesome! And this forum is great. It seems like you
can do
just about anything with an Excel spreadsheet, if you can only figure
out
how.
Thanks to everyone who takes the time to help others put all the
pieces
together.

To that end, my solution was to use the autofilter. Then use the macro
I
found at Contextures to copy the results into a new sheet. The new
list is
exactly how I wanted it.

BTW the problem with my Advanced Filter was that, following the
examples in
the help pages, I had put my criteria range above my list. After
looking
around Contextures, I moved my criteria range to the side, and it
worked just
fine.

Thanks again to everyone.