Auto sort by date in Excel 2007

[ninerfish]

Hello! This is my first post on the forum so hopefully somebody can help me out I'm working with an Excel 2007 spreadsheet and am trying to find out if I can autosort it by date when I enter in a new value (date). I am using columns A through J with the date in column I. I am also using row 11 as the header column (company name, phone, email, etc.) and rows 12 and beyond for the actual values. I would like to autosort the spreadsheet by date (from the earliest date to the furthest out) everytime I enter a new one in. Is this possible? Also, I would prefer this to happen as soon as I enter the date, not just when I reopen the spreadsheet. Thanks in advance!!!

[Richard Buttrey]

Hi,

You'll need a macro to sort it automatically every time you enter a new date. First ensure that all the data in A11:Jnn (where nn is the last row) is in an Excel Table named 'Table1' - alter this name in the macro below if appropriate.

Then in the Sheet_Change event add the following macro

Please Login or Register  to view this content.

To get to the sheet change event go to the Visual Basic Environment (VBE) with ALT-F11, then find the sheet name you're interested in in the Project Explorer window on the left and double click it. In the right hand window click the left had drop down and pick 'Worksheet'. In the right hand drop down pick the 'Sheet_Change' event.

HTH

[ninerfish]

Worked perfectly, you're the man!