You can use Advanced Filters to limit the rows that appear in your worksheet, but their utility doesn’t stop there. In addition to setting multiple criteria to filter your worksheet, you can use Advanced Filters to copy the filter’s results to another group of cells on any Microsoft Excel worksheet. Copying the results of an Advanced Filter saves you time by identifying where you want the results of your filter to be pasted. Rather than applying the filter and manually copying the results to the new location, you can identify the destination when you create the filter.
Under their respective titles, type the criteria you want met.
Select the entire list you want to filter, including the column headers.
Select the cell at the top left corner of where you want the filtered rows to be placed.
For more information on assigning criteria for an Advanced Filter, see "Creating an Advanced Filter".
18.221.163.13