excel sorting row wise with VB Code[RESOLVED]

[afterMoon]

Hi
My excel worksheet contains data like this

A B X A U X A U
11 22 33 44 55 66 77 88
12 13 14 15 16 17 18 19


I want to sort the whole data row wise and to be shown as follows

A A A B U U X X
11 44 77 22 55 88 33 66
12 15 18 13 16 19 14 17

means i have to sort the block of data based on the coloumn header.
I'm not familiar with the VBA codes so please help me.


Thanks in advance

[RobDog888]

No VBA needed here. You can use the sort method but column sorted instead
of the defaullt row sort.

Step 1. Click Data > Sort... > then click Options... button.




Step 2. Change the sorting to "Sort left to right."




Step 3. Change the Sort By to "Row 1".




Done!

Results:
A	A	A	B	U	U	X	X
11	44	77	22	55	88	33	66
12	15	18	13	16	19	14	17

HTH

[afterMoon]

Thank you very much Mr.Rob. You saved my time!.
Thanks again

-afterMoon-

[RobDog888]

No prob. Glad to help.