filtering data

When a filter is in place, doing a copy and paste will only copy the visible items.

So to answer your question, yes it is possible. Apply a filter, copy the result to a new workbook, save that workbook as new file.

Thanks If I enforce a filter on one column, it appears that I'm losing the filter when I moved and chose my next filter column. 

Select all the data or at least all the headings before applying the Auto Filter. You will then get a dropdown against each header with the filter options.

When you filter on one column, the available filter options for subsequent columns will only show the values which are still visible from first filter.

So if I have 2 columns in a spreadsheet and  I want to use as filters eg. Active and ProductActive and the ideal situation is If I marked PartActive = True, ProductActive should be True as a rule . Both should have true values. But what if  certain ProductActive rows  were not marked as True but it should be True, what is the safest way to it-Filter by ProductActive first then Active?  If express in an SQL query ,  it should be something like 

"If Active = True AND ProductActive = True..." This is the type  filter test I  have in mind...