In a spreadsheet of expiration dates and names, the sort function can be used
or a Macro can be set up to sort the dates in ascending order. Is there a
way that the dates will automatically sort without having to click sort or
run macro? For example, if the date is changed from 5/21/09 to 5/21/10, we
want excel to sort immediately when it is changed without having to do
anything else. This may not be possible but it would be extremely helpful to
our sales staff.