Hello, I have a worksheet with with 10 columns of data used references in a data validation list. I want to automatically sort the column when new data is added. For example:
Column A = Inquiry Status (Closed, Open, Pending)
Column B = Source (Internal, External)
Column C = Country (Australia, Belgium, China, etc.
etc. etc.
If I add a new Country to Column C, I would like just Column C auto sorted with the header in C1 remaining in place.
If I add a new Source to Column B, I would like just Column B auto sorted with the header in B1 remaining in place.
Etc. Etc. Any help would be appreciated.
Column A = Inquiry Status (Closed, Open, Pending)
Column B = Source (Internal, External)
Column C = Country (Australia, Belgium, China, etc.
etc. etc.
If I add a new Country to Column C, I would like just Column C auto sorted with the header in C1 remaining in place.
If I add a new Source to Column B, I would like just Column B auto sorted with the header in B1 remaining in place.
Etc. Etc. Any help would be appreciated.