Automatic Update when entering data in a new row [or cell]

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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