Select your filtered data. Press F5 Key. click on Special button. then click
on "Visible cells Only". copy and paste data.

" 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?