Question about sorting automatically

[confused1]

I hope this is a really easy question. Unfortunately, I've been searching for hours and can't find the solution.

Is there a way in Excel (I'm using 2003) to define a sort order for several columns and then, have Excel keep those columns sorted.

In other words every time I add a new row to the sheet, that row gets moved to the proper location in the sorted list. This way the list is always sorted correctly.

Thanks!

[shg]

Via the user interface, and in a word, no.

You could use VBA to automatically and dynamically re-sort a range, or you could have another range that retrieved values from large to small in the designated range, to mimic the functionality of a sort.