Thread: "Mass" Delete
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Liam Tutty
 
Posts: n/a
Default "Mass" Delete


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