Liam, you can use autofilter on the data and select blanks in column E then
select the rows and edit delete row, or you could use a macro like this

Sub Delete_blank()

'Will delete the whole row where there are blank cells in E1:E500

[E1:E500].SpecialCells(xlCellTypeBlanks).EntireRow.Delete

End Sub
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"Liam Tutty" wrote
in message ...

Does anybody know of any way to do this...I have to compile a
spreadsheet every month for work, and always end up spending hourse
deleting rows where the information is not all present. Is there any
way I can say, Delete every row which has no information in Column E.

This would save me literally about 4 hours at the end of each month.

Thanks in advance,
Liam.


--
Liam Tutty
------------------------------------------------------------------------
Liam Tutty's Profile:
http://www.excelforum.com/member.php...o&userid=29704
View this thread: http://www.excelforum.com/showthread...hreadid=494156