Automatic Sorting Help

[ozstephan]

Hi everyone:
I'm not sure whether I'm asking too much with this wish but I'll give it a go. I have a shared worksheet which consists of 14 columns and approx 100 rows. It is a working document with many users and growing in size. It also has a column which automatically records the last time anything was updated in the corresponding row. This is column 'B'

So what I would like to be able to do is for the spreadsheet to sort in the same way as a Data>Sort but do it by date automatically everytime the date in column 'B' is changed or at least each time the worksheet is saved.

Is this possible?
Thanks everyone.

 

[Joe4]

Sure, you can do that with VBA code. There is VBA code that is automatically triggered by "events", such as changing the value of a cell, or saving the workbook. These are called Event Procedures.

Here is a good link on Event Procedures:
http://www.cpearson.com/excel/events.htm