Need to get rid of blank rows without sort
 

or maybe with sort I don't know. All data in Column A several rows between
data. When I sort, all numbers go to top and names and ids drop to bottom.
How to maintain data integrity in the group and still delete the rows?
--
ALFR

Select the whole column A by clicking on its letter. Edit--Go
to--Special--Blanks, OK. Edit--Delete, Choose Entire Row. This often
works. Hope I understood.
************
Anne Troy
www.OfficeArticles.com

"Arlene" wrote in message
...
or maybe with sort I don't know. All data in Column A several rows between
data. When I sort, all numbers go to top and names and ids drop to bottom.
How to maintain data integrity in the group and still delete the rows?
--
ALFR

check out auto filter
select column A
<data<Filter<Autofilter
click on the little arrow at the top of column A and select blanks
select the cells where the row numbers are colored and dlete the rows
turn off autofil

"Arlene" wrote:

or maybe with sort I don't know. All data in Column A several rows between
data. When I sort, all numbers go to top and names and ids drop to bottom.
How to maintain data integrity in the group and still delete the rows?
--
ALFR

You might be able to apply an autofilter (DataAutofilter), show
"non-blanks" and then copy the results to a new sheet (this doesn't delete
the blank rows as much as it "leaves them behind"). The problem is that
Autofilter isn't crazy about entirely blank rows.

A non-code Alternative:
1) add a column to your data
2) insert a series of sequential numbers into this column (not formulas,
values).
3) Sort on some other field with data/blanks in it (making sure the
sequential # column is included in the sort)
4) Delete the blank rows that float to the top/bottom
5) Re-sort by your sequential value column.

That should put your data back in its original order without blank rows.

In either case, BACKUP first.

HTH,
--
George Nicholson

Remove 'Junk' from return address.


"Arlene" wrote in message
...
or maybe with sort I don't know. All data in Column A several rows between
data. When I sort, all numbers go to top and names and ids drop to bottom.
How to maintain data integrity in the group and still delete the rows?
--
ALFR