Default Sort

[Uly]

How do I program Excel to Sort everything by the data in the 5th column automatically, by default
Is that possible? or do I have to go in and sort it every time myself?

 

[Frank Kabel]

Hi
you may use the worksheet_change event to check if new data has been
entered but I would recommend to sort manually

 

[Uly]

Thank you Frank for responding! I will continue to do it manually it's just that I forget to re-sort it everytime... then people send it back to me to correct Once again thank's for your help.

 

[David McRitchie]

Hi "Uly" <[email protected]>,

See my reply to "cgables >" <[email protected],
a few minutes ago in subject: sorting in either of
news://msnews.microsoft.com/[email protected]
http://google.com/[email protected]

 

[Dave Peterson]

I'm not sure if Frank meant sort the data manually or initiate a macro manually
(not automatic).

You may want to try recording a macro when you do the sort manually. Then tweak
that macro (post back if you need help).

Then whenever you want to sort, just run that macro.

 

[Et3rnal]

Im not sure if you can program it to sort on startup. But if you go t
the forms toolbar and insert a button you can assign a macro to sort b
that colum. It may not be the solution you are looking for, but i
will allow you to sort by one click of a button rather than goin
through the steps.

Et3rna