Home

you can only copy filtered data to the active sheet, copy data to another worksheet with Advanced Filter, MS Excel 2003: filtered data to a new worksheet