Automatically insert list entry

[oliverj]

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

[Dave Peterson]

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