How to do auto sorting

Originally Posted by toddgold

Best way around it would be to write your own sorting algorithm, then apply the resultant sort order to all the linked sheets. ie. Don't use the Excel auto sort.

toddgold
thanks for your reply. Actually i am a total noob in excel programming. i also hope to learn how i could do the trick.