excel needs feature to delete blanks when autofilter is used.
 

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.

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
HIS

"bobz666" wrote in message
...
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.

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

http://www.cpearson.com/excel/deleti...eleteBlankRows

HTH
Jason
Atlanta, GA

-----Original Message-----
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.
.

Hi bobz666

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


--
Regards Ron de Bruin
http://www.rondebruin.nl



"bobz666" wrote in message ...
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.

can you not filter for the blanks prior to importing?

"bobz666" wrote:

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.

please ignore, I miss read the question...

"Simon Shaw" wrote:

can you not filter for the blanks prior to importing?

"bobz666" wrote:

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.

bobz666

Have you tried F5SpecialBlanksOK?

Then EditDelete. Entire Row or Shift up or left.


Gord Dibben Excel MVP

On Tue, 1 Feb 2005 16:05:01 -0800, "Simon Shaw"
wrote:

can you not filter for the blanks prior to importing?

"bobz666" wrote:

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.

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.

"Gord Dibben" wrote:

bobz666

Have you tried F5SpecialBlanksOK?

Then EditDelete. Entire Row or Shift up or left.


Gord Dibben Excel MVP

On Tue, 1 Feb 2005 16:05:01 -0800, "Simon Shaw"
wrote:

can you not filter for the blanks prior to importing?

"bobz666" wrote:

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.