Selecting Rows

  • Thread starter Thread starter Alan
  • Start date Start date
A

Alan

Hi,
I'm importing into XL data from an MS-DOS application, I really don't
know what type it is. I have to delete lots of bits and pieces which are
different on each download so it has to be done manually.
When I'm done, I end up with the data I want, but with a row beneath
each meaningful row that is not empty, but of no use to me, and I want to
delete all these rows. There can be up to 1500 or more rows and deleting
every other row by hand is very tedious.
Could anyone please explain how to SELECT every other row, either odd or
even so I can delete them? I don't want to delete automatically as I want to
check it first,
TIA,
Regards,
Alan.
 
Alan,

Don't know if this will help but if there is a column in your "useless" rows
that is blank, and cells in the "good" rows always have something you can do
this:

Select this column.
GoTo Special Blanks
Delete Entire rows

You can record this and build a macro.

If there is an identifiable 'string' in these rows that is not in the other
rows,
you can precede the above with a Replace 'string' With
(don't put anything in the with box).

This is a fast approach to delete blank rows.
Other wise you have to build a loop and start from the bottom.
(this is the slow way)
 
Steve,
Thank you so much, too much thought, wood and trees etc on my part,
Thanks Again,
Alan.
 
Alan,

Sounds like it works!!! Glad it was a 'simpler' solution...

Excel can do that to you...

And - You're very welcome!!!
 
Back
Top