Auto Sorting

[MarieB]

I would like to be able to enter data into a worksheet and have the data auto sort as it is entered. I have tried using macros (not real familiar with) and could not get it to successfully update. Here is an example of my worksheet.

<table border="0" cellpadding="0" cellspacing="0" width="652"><col width="103"><col width="180"><col width="70"><col width="87"><col width="212"><tr height="20"> <td class="xl72" style="height: 15pt; width: 77pt;" height="20" width="103">Ticket #</td> <td class="xl70" style="width: 135pt;" width="180">Agent
</td> <td class="xl65" style="width: 53pt;" width="70">Reviewer</td> <td class="xl64" style="width: 65pt;" width="87">Date</td> <td class="xl66" style="width: 159pt;" width="212">Comment
</td> </tr></table>

I would like column A (Ticket #) to be the primary sort and up date as data is entered.

Thank you for your help

 

[MarieB]

It must be something I have set up incorrectly as I do not get any results even when using your downloaded file with macro enabled. Not sure if need to run macros or exactly what my malfunction is. I may just have to resort to the old fashioned way of highlighting the document and using the sort feature with each addition of row. Thank you for your help, will have to chalk this one up to operator error - CFS