sort a to z

i wanna sort a to z in a table , i can do it but after entering new date i need to do it again ? is there any way to sort automatically without need to click sort a to z again ?

If VBA is an option to you, this can be done quite easily.

A piece of code would run each time you change a cell in a specified range and that code would resort the table.

BSB

so i can not do it out of vba ?

I don't think you can automatically sort the data in place without VBA. You could have the list sort elsewhere using formulas alone, but not the actual list itself sorting.

BSB

its 2016 version

In VBA it is not really hard. This is all you need behind your worksheet module(where the table is located)

Please Login or Register  to view this content.