How to sort on column C, but not include any rows with an x in column L

I closed the original Thread and built an example. Hopefully the explaination is good.

I believe that the best way to evaluate this request is to look at the example. I have 2 buttons to demonstrate what I need, along with written instructions.

eMailSampleTest.xls

Hope this works.

Question: If someone can show me how to sort column L so that the blanks are at the top of the list and the x's at the bottom, I can do this application.

You can filter your table and deselect the x's in column L and the blanks in column G before sorting.

Hi - ProtonLeah

Good suggestion, but I still have a problem after filtering/sorting per your suggestion.

This program is an eMail tracking program and I need the eMails selected and copied at the finish of the macro. The user then clicks over to their eMail program and pastes the addresses into the TO: box and it is ready to be sent.

Now, the problem as I see it, is that after the eMail is sent and the user returns back to this eMail list, all they see is the filtered list. This program has 27 sortable columns and if I set up each column to use your filter suggestion, I don't know what would happen if the user then selected another column to be sorted. Would the original filter be removed and everything starts over?

Also, how would the user return to the original full list.

Do you still think that this is useable? If you do, I'm going to need some major help.

P.S. The current program works perfectly. What I'm trying to do now is not include certain eMail address when sending eMails. I don't want to delete the eMail completely. I guess I could and copy them to a storage list on another tab.