Dear all,

I've a table of records. Each record is filled in the spreadsheet by a macro
automatically. Column B is for the "Department's name" and column E is for
the "input date". When each record is filled along the rows, the department
name is not in order. Please advise how to sort the department name in
ascending order automatically and subject to the input date (records with
earlier date come first) whenever a new record is entered?

Thanks in advance