Filter to a a new sheet

[Wasalome]

Hi Team,

is it Possible to filter a table and Excel to automatically paste the filtered content to new sheets in the same workbook?

Kind regards

Paul Kimani

[#2]

@Wasalome 

Depending on the version of Excel and what you want, the solution could be a dynamic array formula, a manual process using Advanced Filter / Extract or a VBA/Typescript module.  The first requires Excel 365

= FILTER(Table1, Table1[criterionRange]=CriterionValue)

[#3]

@Wasalome 

Sub CopyVisibleRange()    
    ActiveSheet.UsedRange.Offset(1, 0).SpecialCells _
        (xlCellTypeVisible).Copy _
        Sheets("Destination").Range("A" & Rows.Count).End(xlUp).Offset(1, 0)
End Sub

[#4]

Peter, did you have a suggestion on the latter part of this question, how to automatically past the filtered dynamic array content to new sheets in the same workbook? Thanks