excel needs feature to delete blanks when autofilter is used.

[Guest]

I frequently import large data files in which data overflows the column
creating blank lines plus there are also blank/incomplete data records.
Deleteing the blanks involves turning on autofilter, selection that column,
scrolling to the bottom of data in the list box to the "blanks" and selecting
it. then selecting all the row numbers that is lists, deleting the rows, then
hitting show all data again.

 

[Nick Hodge]

Bob

I know this is not the case all the time, but bear in mind for completely
blank rows, you can sort the data and the blanks will sort to the bottom

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[Jason Morin]

MVP Chip Pearson has some code on his site that may be
able to help you:

http://www.cpearson.com/excel/deleting.htm#DeleteBlankRows

HTH
Jason
Atlanta, GA

 

[Ron de Bruin]

Hi bobz666

Maybe you like this Add-in
http://www.rondebruin.nl/easyfilter.htm

 

[Guest]

can you not filter for the blanks prior to importing?

 

[Guest]

please ignore, I miss read the question...

can you not filter for the blanks prior to importing?

 

[Gord Dibben]

bobz666

Have you tried F5>Special>Blanks>OK?

Then Edit>Delete. Entire Row or Shift up or left.


Gord Dibben Excel MVP

 

[Guest]

looks interesting, ill try it tomorrow, but my original idea stands. There
are usually many ways to do things in excel, but sometimes program coding can
do it best.