Remove Excel lines with an empty cell

[gc6294]

Is there a way to execute a script that would remove all rows in an Excel spreadsheet if a certain cell on that row is empty. For example, would like to automatically remove all rows where cell H in that row has no value. Is that easy to do? Thanks

 

[krets]

You could use the Sort option in Excel to sort by the row you want to check for blanks. That would put all the blank rows together then you could quickly select and delete them.

Just select the range of data you want then go to

Data > Sort

Choose the column you want to sort by and leave it as Ascending. That should bring your blanks to the top.

 

[gc6294]

Thanks - I was hoping for something a little less manual, but, yes you are correct, that would work.. Thanks

 

[LNBruno]

Maybe this is more along the lines of what you had in mind?

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

< M!ke >
Acupuncture Development: a jab well done.

 

[GlennUK]

You could use the Data Filter command to manipulate your data too.



Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[AnotherHiggins]

For future reference, VBA/Macro-specific questions should be posted in forum707.

But, to answer your question, this will do it with a single line of code:

columns("A:A").SpecialCells(xlCellTypeBlanks).EntireRow.Delete

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.