Re-sorting the order of real-time data?

[danjuma]

Hello,

I have some columns of data of any number of rows updating every few seconds. The data is returned in ascending order based on the date/time (i.e. oldest at the top and newest at the bottom). Is there a way I could display this in descending order (i.e. the newest at the top and oldest at the bottom) automatically? Many thanks

 

[RichardMGreen]

How is the data being refreshed? Where is the data coming from?

 

[danjuma]

How is the data being refreshed? Where is the data coming from?

Currently the data comes from a stock quote datafeed and it is imported into excel when I manually click a button in excel to activate this. However, I intend to find a way to automatically request this so it automatically gets imported into excel at specified times, hence reason I want it sorted automatically. Thanks

 

[RichardMGreen]

It sounds like the import is automated via VBA.
If so, you can add a sort routine to the end to sort it however you want to.
Record a macro sorting your data and you should be able to edit it to do exactly as you want.

 

[danjuma]

It sounds like the import is automated via VBA.
If so, you can add a sort routine to the end to sort it however you want to.
Record a macro sorting your data and you should be able to edit it to do exactly as you want.

Ok, will give this a try. Many thanks

 

[danjuma]

Ok, I have had a look at the VBA code, unfortunately VBA is not one of my strongest points, and struggling a bit to understand. Is there a way in excel to sort of automatically re-display the values in different columns in the order I want if you know what I mean. i.e. formula to display values in say columns A, B, C, D, E, F in the descending order in columns G,H,I,J,K,L based on the date/time in column A?

Thanks

 

[RichardMGreen]

You shouldn't need to move the data items to different columns if the sort works correctly.

 

[danjuma]

You shouldn't need to move the data items to different columns if the sort works correctly.

Sorry, looks like I have not explained myself properly. I have not done the sort yet as I do not know how to integrate the recorded macro code with the VBA code for the data request. I am not very good with VBA and don't understand the VBA code for the data request to be able to integrate my recorded macro code. So, I was asking if there was a way I could achieve this just using excel formula? Thanks

 

[danjuma]

Is there really no way to achieve this using just excel formula?

 

[RichardMGreen]

Can you post your current code with some sample data?
Adding the sort routine to your current feed should not be too difficult.