View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] ben.lopresti@gmail.com is offline
external usenet poster
 
Posts: 5
Default Excel List Sorting

I am trying to keep my records in Excel, and I want to keep the list
sorted by "Last Date Contacted". This column is constantly being
updated, depending on when the person was contacted last.

Right now, I have to sort the list after each change to a cell in the
"Last Date Contacted" column. Is there any way to make the list
automatically sort itself in real-time, based on any changes that I
make to this column? (when I change the date, the row would
automatically jump to its proper place, based on the new date)

Thanks a lot.

-Ben LoPresti