Hello, I'm new to VBA and I've got some problem with a macro, here's my problem:

I got 6 columns with 204 rows each with on the top the average value of the column

What i need to do is to sort the 6 column in descending order regarding their average value, ( so replace the first column with the value of the best one and so on ) what can I do ?

I've already tryed to follow the steps here Sorting Cells using VBA but it's not my case and I'm very bad in VBA programming..

I'll try to wxplain better my problem with an example, I got this data:

2 4 1 5 25 18

1 5 4 3.8 15 17
8 15 12 7 1 2.3
12 2 2 8 5 6

in which on the top I've got hte average value of the column and in the column all the data, I need to sort first the row with the average value, than give them a rank ( without lost of any information regarding their corresponding column ) then sort the column regarding the new rank

I know that might seems really difficult, but please can someone halp me ?

any comments will be gladly accepted

Thanks in advance !