以自定义方式对Excel进行排序 [英] Sorting an excel in a custom way

问题描述

我想在Excel宏中创建一个用户窗体.单击该按钮即可对excel进行排序.
我在以下方面表现出色.

Hi,
I want to creat a userform in excel macro. which on clicking will sort the excel.
I have an excel in a following way.

COL-A COL-B
1     q
1     a
1     a
1     g
1     l
1     t
2     i
2     j
4     p
4     f
5     y
5     x
6     m
7     b

我想按以下方式对其进行排序.

I want to sort it in the following way.

COL-A    COL-B    COL-C    COL-D    COL-E    COL-F   COL-G    COL-H
1          q        a        a        g        l       
           t

2          i        j

4          p        f

5          y        x

6          m       
 
7          b

如所见1在A列中出现了5次，所以无论什么值都对应于
1 ...应以差异列的形式排列，但应使用最大5的列.其他柱子


[edit]已删除呼喊声-OriginalGriff [/edit]

as seen 1 is appearing 5 times in columb-A so whatevery values are corresponding to
1...should be arranged in diff columb but max 5 columb should be used. likewise the other columbs


[edit]SHOUTING removed - OriginalGriff[/edit]

推荐答案

请大家帮我提供代码，如果可能的话会很有帮助

Guys please help me with the code if possible it wil be a great help

这篇关于以自定义方式对Excel进行排序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！