Sorting left tor right in groups of 3 columns based on the total of one column in each...

[Hyflex]

Hey,

I'm trying to sort groups of data (columns of 3 = a group) based on the highest totals from the middle column of each group however I have no idea where to start and how to do it.

For a screenshot please click the following link \1 or use the attached image

It's easiest to show in the excel spreadsheet so, please see the attachment below.

Any help would be much appreciated.

[Bernie Deitrick]

In cell E15, enter the formula
=SUM(D14:F14)+0.1/COLUMN()
and copy to F15:S15, then select E3:S15 and sort horizontally, descending, based on row 15.

[Hyflex]

In cell E15, enter the formula
=SUM(D14:F14)+COLUMN()/100
and copy to F15:S15, then select E3:S15 and sort horizontally, descending, based on row 15.

The totals are only there to show what it's supposed to achieve, I don't have that in my real data and I don't want to input data into any cells, it's all got to be done in vba :/

To show I tried, I did the following:

Please Login or Register  to view this content.

But sorting it failed misserably, it just put all the "TOP" columns to the left, didn't keep them in "groups"

[Bernie Deitrick]

Try

Please Login or Register  to view this content.