Moving data row up according to date column

[Jo4x4]

Hi everybody,

I have a workbook with data being transferred to a worksheet via VBA. One of the columns it a date field.

Sometimes, a "late entry" is made, and this results in the row not being in the correct place on the results sheet. How can I get it to automatically sort according to the date column?

Thanks in advance
Jo
Win XP Office 2007

 

[JackDanIce]

Have you tried to record a macro where you have the dates in non-sequential order, then reordered your data, to see what code is produced?