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
Bookmarks