Forum Discussion
Filter to a a new sheet
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
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)- 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
