mscs
03-19-2012, 04:13 AM
Hi,
I am facing trouble in sorting.
I want to sort each row with respect to each column label through MACRO.
For Example: Top row heading is "shopk's" and there are four other columns in row 1 like TV, Refrigerator, VCD and Microwave.
Shopk's TV Refrigerator VCD Microwave
Shopk1 4200 4500 4300 4450
Shopk2 4400 4200 4100 4350
Now I want to sort each row in descending order with respective column label (heading). "Shopk1" data should be sorted like this
Shopk's Refrigerator Microwave VCD TV
Shopk1 4500 4450 4300 4200
and the data of "Shopk2" should be sorted like
Shopk's TV Microwave Refrigerator VCD
Shopk2 4400 4350 4200 4100
I am very confused, Please help me to solve this problem through macro.
Best Regards,
I am facing trouble in sorting.
I want to sort each row with respect to each column label through MACRO.
For Example: Top row heading is "shopk's" and there are four other columns in row 1 like TV, Refrigerator, VCD and Microwave.
Shopk's TV Refrigerator VCD Microwave
Shopk1 4200 4500 4300 4450
Shopk2 4400 4200 4100 4350
Now I want to sort each row in descending order with respective column label (heading). "Shopk1" data should be sorted like this
Shopk's Refrigerator Microwave VCD TV
Shopk1 4500 4450 4300 4200
and the data of "Shopk2" should be sorted like
Shopk's TV Microwave Refrigerator VCD
Shopk2 4400 4350 4200 4100
I am very confused, Please help me to solve this problem through macro.
Best Regards,