Rather than use the Data > Sort > Descending option, I was wondering if it is possible to create a function that would automatically set a new entry in alphabetical order.
The range is A4 to A100.
Some have given me a solution to this but it includes A1 to A3 in the alphabetical sorting. I don't want that. I want to specify the sorting within a certain range (A4 to A100).
Say I have a list of animals starting at A4.
A4: cats
A5: dogs
A6: elephants
A7: zebras
> I then want to add aardvark at A8
I want the aardvark entry to automatically be placed in its appropriate alphabetical spot - at the top of the list.
Can anybody provide tips on how I accomplish this?
Bookmarks