Sort by specific column & delete rows based on content

Hi all,

I need help with code that does the following. Attached book has some sample data I need to sort A-Z by column B. Once sorted, any rows having content ONLY on column A, I need all those to be deleted.

Attached book contains only 30 rows, but I usually deal with a few hundred or sometimes a few thousand rows per spreadsheet.

Thanks for your help!

Perhaps

Please Login or Register  to view this content.

Hi Jindon,

Thank you so much for your help. I tried the code and it sorted the data as needed but ... rows having data only on column A were not deleted. Not sure what's happening?

Thanks

Correct, Should be like this

Please Login or Register  to view this content.

Hi AlphaFrog!,

I tried your code and it worked exactly how I needed it. I'll test it tomorrow extensively at work and, if everything goes well, I'll mark this post as solved and will certainly add reputation to you!

Thanks!

Hi both Jindon & Alpha Frog,

First of all, I apologize it took me this long to get back to you guys. Both options work as intended. I'm marking this post as solved and adding reputation to the both of you.

Thank you so much for your help!