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 for posting this in the wrong place... I didn't realize I had
scrolled the mouse when I looked up for a moment while typing.

So, sorry about that.

m

"MatthewS" wrote:

>
>
> 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