Advanced Filter allows you to generate a unique list of items and extract those items to another place in your worksheet or workbook.

Note that you should always start your Advanced Filter from the sheet where you want your results to appear. Click the Data tab on the Ribbon. Then choose Advanced from the Sort & Filter group, and ...

Microsoft Excel’s Advanced Filter feature displays records that match specific criteria. You can also limit the columns returned by this feature.

There are multiple ways to transfer your data across Excel worksheets and workbooks. You can copy data from one sheet to another, or move an entire sheet to another workbook altogether.