Hi,

I have imported realtime currency prices into an Excel spreadsheet using DDE links, if I have 5 rows showing the last 5 days prices the data is displayed with the most recent days record at the bottom of the table however I would like the most recent records to be displayed at the top.(dates are in European format) 

ACTUAL RESULT
11/01/2007 1.9536
12/01/2007 1.9607
15/01/2007 1.9668
16/01/2007 1.9705
17/01/2007 1.9666

DESIRED RESULT
17/01/2007 1.9666
16/01/2007 1.9705
15/01/2007 1.9668
12/01/2007 1.9607
11/01/2007 1.9536

I have tried sorting the data by the date column, however because it is an array it will not allow this in Excel.

I know I could paste link each row into another area of the spreadsheet so as to invert the data and maintain the DDE links; this is fine if I only have a few rows but if there are hundreds then it is a bit time consuming.

I was wondering if there was a better method of inverting the data so that the most recent records appear at the top of the table, ideally by setting it up in Quotecenter before export  rather than Excel.

Thanks for the ideas.

Ade