Getting More out of Advanced Filters
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.
Copy Filtered Rows to a New Location
Copy ...
Get Microsoft® Office Excel® 2007 Plain & Simple now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
