Filter to a a new sheet

Question

Hi Team,&nbsp;is it Possible to filter a table and Excel to automatically paste the filtered content to new sheets in the same workbook?&nbsp;Kind regardsPaul Kimani

peterbartholomew1 · Answer

Wasalome&nbsp;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.&nbsp; The first requires Excel 365= FILTER(Table1, Table1[criterionRange]=CriterionValue)

juliano-petrukio · Answer

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

literascriptamanet · Answer

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

Forum Discussion

Filter to a a new sheet

3 Replies

Resources