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 when
they hit the save button.
Can anyone please help? I would greatly appreciate any
help.

Thank You!

 

[Guest]

In excel you can learn a lot of programming by Recording a
macro. I recently did the same for my excel. I populated
sample data, started recording a macro, sorted the data
based on columns, stoped the macro, reviewed the macro
code and modified to fit better. May be you can do the same
Hope this helps.