Suppose you have a list and you would like to just copy selected information.
You have a way! Use filters.
Filter the information (check out our earlier lessons on using filters)
Use a second or third filter in sequence until you get the list down to what you want.
Now you have what you want shown on the list.
Then highlight those rows
Copy them to another sheet
You may also want to copy the header row from the list also
The beauty of it is that you are only copying the rows that are displayed. For example, suppose after you do your filter, the rows 14, 88, 199, 403 and 777 are displayed. When you do the copying, only those 5 rows are copied. None of the hidden rows in between get copied.
When done with the copying, you can then unfilter the list to go back to displaying the whole list.
This is a great way to pull out just the information you need from lists for highlighting or doing analysis on in a separate sheet.