Try using Edit | Go To... Special... Visible Cells only prior to
copying.

HTH,
Bernie
MS Excel MVP

"MeliDe" wrote in message
...
After performing an AutoFilter in Excel 2002, I end up with thousands of
blank rows when I copy the filtered info to a new worksheet? Anyone else
experience this? It makes the filtered file huge, when it should be
smaller
than the original! Any ideas on how to alleviate this?