Hi All,

Thank you in advance for all the great tips. This site is amazing.

I have a column where I created a drop list with the options recent, completed, and also a blank field option. I need excel to automatically sort this. When recent is selected that row moves to the top, when completed is selected it moves to the bottm, and the blank field goes in the middle. What is the best way to achieve this goal?

Thanks!

Summer