If I have a spreadsheet with four column, and rows starting at row 2
[headings are in row 1], and increasing daily.

One of the columns is a "priority" column, which is 1 [for the highest] down
to 5 [for lowest].

I'd like to sort the data each time a new row is entered, such that the
highest priorities are listed first.

Is there a way for this to happen automatically? Or would I have to, at the
least, create a Macro and put that button on the toolbar to press when I want
a sort to take place?


Any help would be greatly appreciated.

Thanks.
m

[I apologize that this accidentally went in the FrontPage forum as well...
sorry about that].