I want to automatically filter a column as data is added. The catch is I want Column D to stay the same and I can add data into column D for a drop down menu. But I want column E to be a filtered version of column D in ascending order. Example is attached and I have want I am looking for in green. One special catch/issue, can you filter out text or cells to be exclude in the sort. I do not want to sort "other customers".
I am using Column D in 2 seconds:
1. Main Customers
2. Other Customers
Thanks
Bookmarks