If you are new to macros Set the Security level to low/medium in
(Tools|Macro|Security). 'Launch VBE using short-key Alt+F11. On the left
treeview right click 'This Workbook '. Paste this code and save. Get back to
Workbook.
This will sort Column A everytime you open your workbook.

Private Sub Workbook_Open()
With ActiveWorkbook.Worksheets("Sheet1").Sort
.SetRange Range("A:A")
.Header = xlNo
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
End Sub


If this post helps click Yes
---------------
Jacob Skaria


"Michael Koerner" wrote:

I would like to be able to sort Column A by it's self from the top to whatever the last cell entry falls, ignoring all the other columns. Is there a macro around that will do that? TIA

--

Regards
Michael Koerner