automatic sorting

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

Guest

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
 
use the worksheet_change function

-----Original Message-----
is there a way to set an area to sort by a column
Click to expand...
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
Click to expand...
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.
 
Back
Top