Re-ordering some columns (groups of columns)

Hey

I must put in descendent order some columns, but the thing is a bit more complicated...
As my english is not very good i am gonna explain it with a simple example:

----------------------------------
1 4 2 5 rabit fox dog cat
2 6 1 3 bird fis wolf mouse
----------------------------------------

Ok, i must order the numbers in a ascendent way, but reordering one number means also reordering its correspondient name (the name of the animals at its right).
So, again, with an example you will see it better:

Ordering the first row it must appear like this:

----------------------------------------------
1 2 4 5 rabit dog fox cat
----------------------------------------------

I didnt know if i had to post it here or in other subforum and either if it can be done with excel.

Can someone help me?
Can it be done with excel?
If not, how could i do it?

Lots of thanks

See you!

Ok, i dont know if it hepls a lot, but well.

Originally Posted by stanleydgromjr

pepito,

See the attached workbook.

Your original sheet "Hoja1", range A1:K10.

Is sheet "Hoja1", range A19:K28, sorted correctly ?


Have a great day,
Stan

O yeah!!
Impressive

Lots of thanks man, how did you do it?

Originally Posted by stanleydgromjr

pepito,

Open the attached workbook, and run the "ReorderColumns" macro.

Have a great day,
Stan

Thankyou again Stan, thousands of thanks

Only a little stupid problem I made a little mistake when i posted. I wanted to say that values had to be ordered in descendet way, not ascendent.

Sorry for the mistake. I hope it wont be too difficult to change it in that macro.

Thank you.

Thanks again Stan

Sorry, you are gonna kill me, but i forguet that i had to do it not only with 2 groups of columsn, but with 5.
I hope i wont be too difficult

You will find 5 groups of colums in the file:
-c1, c2...c5
-type c1, type c2...typec5
-subtype c1, subtype c2...subtypec5
-style c1, style c2...style c5.
-orienta c1, orienta c2,...orientac5

You did it with 1st and 2nd group of columns (c and type).
But i have just remember that i must add some other columns and do the same with them.
I mean, column c must be ordered as you did, and also type columns, but also must work in the same way subtype, style and orienta.

I dont know if i have explained myselft good.
All columsn are related with the 1st group (c1, c2...c5), so if c columns change its possition it must also change the other 4 groups.

Sorry, i forguet to tell it in the post i think it would had been simple to implement it only one time...

Thank you Stan, and lots of sorrys

Attachment file for the example:

Is it very difficult?