auto sort

[mharris]

I am running office 2000 and win2k. I have an excel sheet
that has Columns A-E populated by the end user. I would
like the sheet to auto sort ascending by column E. Can
anyone please help? I would greatly appreciate any help.

Thank You!

 

[mudraker]

mharris


Can you enlighten us as to when and how the auto sort macro is to b
activated.

This will help us to determind the macro name and on what module shee
the macro is placed

After user enters data in to column e?
When work book is opened?
When the workbook is being saved?
when a user pushes a button?
At a preset time?
or at some other trigger point