filter and delete
 

I have received a large spreadsheet of information I am trying to clean up.
Based on what is in several different columns a row may or may not need to be
deleted. I have added a column and written a formula (copied to each row)
that says either "Delete" or is left blank. I can then filter the list by
the delete column and get rid of them.

The problem I have is once you unfilter there are blank rows which have to
be sorted to remove. Once completed this is all going to be done with a
macro so I was looking for a cleaner way of doing this.

Any help will be appreciated. Thanks.

Jordan

I figured out that I need to use Advance Filter and have a new question
posted reguarding criteria. Please ignore this post. Didnt know how to
delete it. Thanks.

"Jordan" wrote:

I have received a large spreadsheet of information I am trying to clean up.
Based on what is in several different columns a row may or may not need to be
deleted. I have added a column and written a formula (copied to each row)
that says either "Delete" or is left blank. I can then filter the list by
the delete column and get rid of them.

The problem I have is once you unfilter there are blank rows which have to
be sorted to remove. Once completed this is all going to be done with a
macro so I was looking for a cleaner way of doing this.

Any help will be appreciated. Thanks.

Jordan