Use an Excel Advanced Filter to copy specific items from a list, to a new location.
The extracted data will not update automatically, so record the steps as you use the Advanced Filter feature.
Then, edit the recorded macro, to make it flexible, in case the source data range changes.
See the steps in this short Excel video tutorial.
Duration : 0:5:26