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?