Select your filtered data. Press F5 key. click on "Visible Cells Only". Copy
that data and paste anywhere.

Tell us if it works.....

" wrote:

Myself and a person I work with just installed Excel 2007. If I
filter a sheet and copy the filtered data, Excel will only copy what
is visible. If I try it on my friends computer (using the same
methods and data), his Excel copies all the data, not just the
filtered rows. Any ideas?