AutoFilter Blank Rows
 

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?

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?

Select the filtered list, press F5, select special and visible cells only,
copy and paste

Regards,

Peo Sjoblom

"MeliDe" wrote:

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?

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?

Maybe resetting the lastused cell would help.

Debra Dalgleish has some techniques (both manual and VBA) for resetting the used
range at:

http://www.contextures.com/xlfaqApp.html#Unused

MeliDe wrote:

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?

--

Dave Peterson