Extract Filtered Data
The Extract Filtered Rows tool will take the selected columns from a table (or worksheet range) and output them to a new worksheet. It is designed to be used in conjunction with Excel's built-in row filtering tools available when you use Format as Table in Excel. The Extract Filtered data will only extract the visible rows and selected columns to a new worksheet or workbook.
- Select Source Table: Select the workbook, worksheet, and range where the data is located. The table does not have to be an Excel table - any range will work.
- Select Columns to Extract: Select the columns that you want included in the output table. At least one column must be selected.
- Output To: You can output to a new worksheet or to a new workbook.
- Worksheet name: Optional field to name the output worksheet.