Hi
try using Ron's addin:
http://www.rondebruin.nl/easyfilter.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"MeliDe" schrieb im Newsbeitrag
...
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?