Move data from one Excel sheet to another based on criteria using the filter feature
Open a dataset on an Excel worksheet with filterable criteria.
Select the criteria column from which you want to filter and go to Data > Filter.
Click the small arrow beside the column header to open a drop-down menu.
Regards,
Will