Keep data sorted in table

[domtrump]

In Excel 2007, is there a way (using VBA I'd assume) to keep records in a table sorted by a certain column? That is, each time a new record is added to the table, automatically Sort Descending by the value in a particular column?

Thanks for any assistance.

-Dom

 

[domtrump]

Anyone have thoughts on this?

Thanks,
Dom