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.
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...
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.