"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.

One way is as follows:

In column F (for example) fill down a numerical series.

Sort on column E, the blank cells should be at the top or bottom depending
on how you sorted the data. This should make it easy to delete the rows.

Sort on column F to return to the original sort order.

Delete column F.