There’s a little known tool for PivotTables that will automatically extract the source data to separate sheets based on criteria.
Download the Excel file here: [ Ссылка ]
View my comprehensive courses: [ Ссылка ]
Connect with me on LinkedIn: [ Ссылка ]
0:00 How to extract data to separate sheets in Excel
0:40 Using PivotTables to extract data
4:11 Using FILTER function to extract data
7:23 PivotTables vs Formulas for extracting data
![](https://i.ytimg.com/vi/_ys8qNq1soM/maxresdefault.jpg)