Hi,

I need to know if, when I set up an advanced filter above the table that I
have, I can hide that advanced filter when printing or saving, besides just
selecting specific rows and going for Hide option.

Also, is there a way that I can filter data to some other sheet of workbook
and have those results saved seperately. When I use advanced filter, it asks
me if I want to filter to another location, but I can only do it on a present
worksheet.

By the way, I am working in Excel 2000 and 2003.