Automatically sorting columns by date

[Schizoid Man]

Hi,

I have the following table and a slight ordering problem. Each of the rows
A, B, C, etc has data associated with 5 fixed dates - from 20-Dec-09 to
20-Dec-18. In addition there is one "floating" column added to the end. In
this example, it is the data for column 20-Dec-10.

20-Dec-09 20-Dec-11 20-Dec-13 20-Dec-15 20-Dec-18 20-Dec-10
A 84 49 88 91 26 82
B 9 68 39 89 50 59
C 45 5 46 69 41 38
D 35 28 70 69 47 59

The dates for the "floating" column always change - it could be any date
before, after or in between the five fixed dates. I'd like to sort this data
so that the columns are ordered by dates in increasing order from left to
right.

Any suggestions?

Thanks.

 

[Bernd P]

Hello,

An example:
http://www.sulprobil.com/html/sorting.html

Regards,
Bernd