Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Automatically insert list entry
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can i automatically insert cell values into a comment field? | Excel Discussion (Misc queries) | |||
Automatically insert row between groups of records | Excel Discussion (Misc queries) | |||
Automatically Insert DATE, so that DATE will NOT change | Excel Worksheet Functions | |||
Insert date automatically | Excel Discussion (Misc queries) | |||
how do i automatically sort a list | Excel Worksheet Functions |