automatic sorting

[Brian]

is there a way to set an area to sort by a column automatically after data is entered in a cell in that column
example
A B C D
24-MAY NAME ??? ??? ???
3-APRIL NAME ??? ??? ??
5-MAY NAME ??? ??? ??

i will enter my data in each row starting with cell E then work my way back to A. after entering the date in A i want the rows to sort by column A. (desending) thanks in advance

 

[Frank Kabel]

Hi
this would only be possible using VBA (an event procedure)

 

[tal]

use the worksheet_change function

-----Original Message-----
is there a way to set an area to sort by a column

automatically after data is entered in a cell in that
column.

example:
A B C D E
24-MAY NAME ??? ??? ???
3-APRIL NAME ??? ??? ???
5-MAY NAME ??? ??? ???

i will enter my data in each row starting with cell E

then work my way back to A. after entering the date in A i
want the rows to sort by column A. (desending) thanks in
advance.