In Excel 2007 how do you paste filtered data into a new worksheet without
pasting all the rows? In previous versions the copy - paste function on
filtered rows only pasted the information that was displayed with the filter
on. Now it pastes everything regardless of the filter.