Enter it anywhere in the list, but then select your range (both columns) and do
Data|sort.

If you want to make it more automatic, record a macro when you select the
columns and sort the data. Then you can just run that macro when you want to
sort the data.

oliverj wrote:

Hi,
I'm simply creating a list of ancronyms and their definitions. I want
to be able to enter an ancronym at the top of the excel document and
have it be automatillcy inserted into the list in the correct
alphabetical order.

Any ideas on an easy solution,

Thanks

--
oliverj
------------------------------------------------------------------------
oliverj's Profile: http://www.excelforum.com/member.php...o&userid=25721
View this thread: http://www.excelforum.com/showthread...hreadid=391310

--

Dave Peterson