Hello all and thank you for looking,

I have a program that automatically feeds a set of values into excel. The outside program can only feed into one row, say row 5000, and puts a date and time stamp in column C.

I was wondering when excel is opened by this outside program an event macro can be used to auto sort the previously entered data? If the previously entered data is not manually moved or sorted before the outside program opens excel and enters new data, the previous data is overwritten and lost.

Is it possible to sort by the date/time stamp sequentially so that when the program opens the previously entered data will move to say, row 1? Then the next batch of data will be entered and excel would close. When the program opens excel the next time, the data that was input into row 5000 on the last run will move to row 2, input the new data and close again. etc etc.

Like this

Outside Program opens Excel
Excel Sorts data by date time stamp(oldest in row 1)
Outside program enters new data into row 5000 and closes excel.

Outside Program opens excel
Excel Sorts data by date/time(oldest in row 1, 2nd oldest in row 2 etc)
Outside program enters new data into row 5000 and closes excel.


The oldest data needs to be first in the column.

IF anyone has any insight on this, it would be greatly appreciated

Mike