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.